Conversion of Date in DataStage
Posted: Mon Jan 09, 2006 11:09 pm
Hi all,
I am new to Datastage & Informatica as well. Right now, i am working on migrating the maps from Informatica to Datastage jobs. I had a field in Informatica as EFFDT with expression as TO_DATE('01-01-1900 12:00:00'). How to give the same expression as derivation in DataStage?As per my analysis DS uses Dec 31,1967 as reference dt. for conversions.But how abt the years before 1967?
I am using the derivation in DS as Timestamp(Oconv(Iconv("1900-01-01","D-YMD[4,2,2]"),"D-YMD[4,2,2]")).
Can u give the right solution for this..................
Thanks in Advance
I am new to Datastage & Informatica as well. Right now, i am working on migrating the maps from Informatica to Datastage jobs. I had a field in Informatica as EFFDT with expression as TO_DATE('01-01-1900 12:00:00'). How to give the same expression as derivation in DataStage?As per my analysis DS uses Dec 31,1967 as reference dt. for conversions.But how abt the years before 1967?
I am using the derivation in DS as Timestamp(Oconv(Iconv("1900-01-01","D-YMD[4,2,2]"),"D-YMD[4,2,2]")).
Can u give the right solution for this..................
Thanks in Advance