How do you load partial data after job failed

Source has 10000 records, Job failed after 5000 records are loaded. This status of the job is abort , Instead of removing 5000 records from target , How can i resume the load

Showing Answers 1 - 3 of 3 Answers

Raghu

  • Aug 1st, 2007
 

There are lot of ways of doing this.

But we keep the Extract , Transform and Load proess seperately.

Generally only load job never failes unles there is a data issue.
All data issues are cleared before in trasform only.

there are some DB tools that do this automatically

If you want to do this manually. Keep track of number of records in a has file or test file.
Update the file as you insert the record.
if job failed in the middle then read the number from the file and process the records from there only ignoring the record numbers before that 
try @INROWNUM function for better result.

HTH
Raghu Mule 

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions