Timestamp data loading
Posted: Mon May 04, 2009 4:59 am
Hi,
Facing the problem while loading the data from DB2 to Oracle , The Timestamp column data in the source not loaded correctly to Target .
Using DB2 as source and Oracle as Target.
Datastage server edition : 7.2.1
Source data like : 2009-03-06 13:40:02.000000 Datatype :VARCHAR of length 28
Target loaded as : 06-MAR-20 09.00.00.000000 Datatype :VARCHAR of length 38
Logic used in Transformer derivation for this column as :
Oconv(Iconv((DSLink5.REC_UPDT_DT_TM[1,4]:"-":DSLink5.REC_UPDT_DT_TM[6,2]:"-":DSLink5.REC_UPDT_DT_TM[9,2]),"D-YMD[4,2,2]"),"D-DMY[2,A3,4]")
Here in Target data loaded as 20 09 instead of 2009 and time not showing correctly.Can you provide any solution for this.
Regards,
Arshi
Facing the problem while loading the data from DB2 to Oracle , The Timestamp column data in the source not loaded correctly to Target .
Using DB2 as source and Oracle as Target.
Datastage server edition : 7.2.1
Source data like : 2009-03-06 13:40:02.000000 Datatype :VARCHAR of length 28
Target loaded as : 06-MAR-20 09.00.00.000000 Datatype :VARCHAR of length 38
Logic used in Transformer derivation for this column as :
Oconv(Iconv((DSLink5.REC_UPDT_DT_TM[1,4]:"-":DSLink5.REC_UPDT_DT_TM[6,2]:"-":DSLink5.REC_UPDT_DT_TM[9,2]),"D-YMD[4,2,2]"),"D-DMY[2,A3,4]")
Here in Target data loaded as 20 09 instead of 2009 and time not showing correctly.Can you provide any solution for this.
Regards,
Arshi