Fatal Error: Invalid Julian day - Direct table to table load

HemaV · Post by **HemaV** » Wed Oct 12, 2011 2:44 am

Hi All,
I am performing direct loading of data from table to table. Same table name and same structure used in two different schemas.
Still I'm getting the below error:
Fatal Error: Invalid Julian day

How to resolve this issue.

Design:
ORA stage to COPY stage to ORA stage.

Thanks in Advance,

ray.wurlod · Post by **ray.wurlod** » Wed Oct 12, 2011 1:26 pm

What is the Oracle date picture? What is the DataStage date picture? They have to be functionally the same.

HemaV · Post by **HemaV** » Thu Oct 13, 2011 3:38 am

Thanks for the above query. I will check on this.

I tried using TimestamptoDate function in transformer for the date columns then the job worked fine.