i am reading columns CLOSE_DT AS DATE datatype from source(db2 stage) and inserting into oracle DB using oracle connector stage having datatype as DATE.
The job design is as follows
db2 stage....................tranformer.......................oracle connector stage.
i have tried by using
Code: Select all
StringToDate(select_stats.CLOSE_DT,"%yyyy-%mm-%dd")
XFM_data,1: Data string '08/20/2013' does not match format '%yyyy-%mm-%dd': the value for tag %yyyy has fewer characters than expected.
however i tried by using
Code: Select all
StringToDate(select_stats.CLOSE_DT,"%mm/%dd/%yyyy")
Error message: ORA-01861: literal does not match format string from the oracle stage.
The date from source coming as '08/20/2013' as char.
please help me on this.