Loading Data

[balaid]

Hi folks,
I have a 10,000 records to be loaded. When i ran the job 5000 records has been loaded. After 5000 the job got failed. Could any one let me know how to load the remaining 5000 records.

Thanks in advance..

[ArndW]

Balaid,

I would recommend printing them out and typing them in by hand

Seriously -

please tell us which database you are loading and which method you are using. Whenever records get rejected some description of the error is written, either to the log file or to another file. You can also activate the rejects in your job to get this information.

If this is too complicated or difficult, just try to manually enter at least one of the failed rows into your database and you will get an error message...

Most common cause for rejecting records - constraint violations.

[ray.wurlod]

Describe your job design. What stage are you using to put the rows into the target?
Post any error message that's logged in the job log.