Error while loading data

[pribomb]

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.

[hamzaqk]

thanks for the information

[vmcburney]

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.