Page 1 of 1

Loading data into target through Oracle connector stage 8.7

Posted: Wed Jul 10, 2013 3:57 am
by BMSK
I am loading data into Oracle 11g. through Oracle Connector through Bulk load option.
I am facing the error data type mismatch between colums Source and Taret colums. I cross check the Source as well as Target data base Data type and length are same. Still I unable to load or append data into target table.

Posted: Wed Jul 10, 2013 3:59 am
by ray.wurlod
Does the error message identify which column is the problem? If not, you need to check the defined versus in-job metadata for every column.

A good wat to do this is to import the table definition afresh, storing it in a different location, and compare the newly-imported table definition against the one that you are using.

Posted: Wed Jul 10, 2013 4:03 am
by BMSK
Yes A dataype conversion encounter error row 7 colum 8 like that