DSXchange

I am Migrating Data from DB2 to Oracle.

I am stuck on the timestamp column. If the colum values are null it is being transformed to '*******************' !! I have tried IsNull in the transformation but it does not work. I MUST accept a null value (not a hypothetical date such as 01-01-0001). If I accept the hypothetical value it works but that will break logics in many application where we check for null.

Please let me know what should be done.

Is the column nullable in Oracle, and is it marked everywhere in your job as Nullable = Yes ?

Yes... I did...

Why don't you share with us the details of your job design specific to this field - stages, datatypes, transformations, etc - then perhaps we can spot where things are going wrong.

Looks like issue was with Data. This is resolved now. Thank you anyways.