Hi,
I did not understand your problem quite clearly.
Do you have problem at source or target? Are you trying to convert date to char or string to date?
If it is the former then use to_date function or if the issue is latter then you have to use a combination of to_char>to_date function.
Thanks,
Arun
You can do the changes inside DS.
First, identify the field in which the value 1900.01.01 00:00:00 comes from the source, inside DF_ xx embedded Dataflow. Check what is the mapping for the same to output.
Mostly, there has to be a to_date function like
TO_DATE(DATE_Column,'YYYY-MM-DD')
Change the same to
TO_DATE(TO_CHAR(DATE_Column'YYYY-MM-DD'),'YYYY-MM-DD')
Though there will be a warning, this has to give you proper value in the output. Replace DATE_Column with your actual column in the code mentioned above.
Regards,
Suneer
