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.
Loading data into target through Oracle connector stage 8.7
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.