Error while loading data
Moderators: chulett, rschirm, roy
Error while loading data
I am Trying to load 1,49,283 records in the target table but it is loading only 99957 records and the job runs successfully.
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Check your log for warning messages, is your database complaining? Add a reject link out of your database stage and capture rows that are rejected. Are you using an upsert? Check for duplicates in your data where some rows are becoming updates.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn