Hi All,
I am loading data from Oracle Schema and Put it into the OtherSchema.Mapping is Done is Trasform.The Source Schema Columns are mapped to Target Schema.But Some of the Target Schema need some default values because there is NO Match in the Source Schema.How will I assign Default Date(Sysdate equivallent) in DataStage Trasform.
I tried assigning Oconv(@DATE, "D2-")for the DateColumn what I defined.It is compling fine But it is saying the follwing error while running the Job
"[DataStage][SQL Client][ODBC][Oracle][ODBC]Datetime field overflow."
Please help me......
Thanks & Regards,
K.S.Rajan.
Regarding Oracle Date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: