DSXchange

I got the solution so I am marking this as resolved. Thanks everyone for their suggestions. I used the following in the transformer to convert date(20070718) to date type 07/18/2007. StringToDate(DSLink3.Field005[5,2]:'/':DSLink3.Field005[7,2]:'/':DSLink3.Field005[1,4],"%mm/%dd/%yyyy"). Th...

I am having source data format as yyyymmdd which is of integer type(Eg:20070728).I have to convert it in to Date format and load in Oracle table.The column is "date" type in Oracle.

This is a Parallel Job.

Please advise

Are the Columns in the 17 csv files different or all have same columns.

Hi Chelett, You are right,the input date is in YYYYMMDD formay and the routine is successfully converting it to MM-DD-YYYY.I also wrote the routine to convert the input date to DD-MON-YY format,but still encountering the above error. Can you tell me wheteher TO_DATE() conversion has to be specified....

Hi, I am using a routine for Date field. However, I am getting the error as "Attempt to convert String value "2005-12-14 " to Date type unsuccessful" The input date is in format "20070716" (in YYYYMMDD) Format. I have to load this in Oracle table.The column in Oracle Ta...

I have to load a .csv file with different record format in to Oracle Table. Each data block should contain one header record and zero to many detail records. Eg: A,1,3,date,time B,1,date,time,seq No,transaction made B,2,date,time,seq No,transaction made B,3,date,time,seq No,transaction made Here 1st...