| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: How do you load partial data after job failed
Answer: 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 |
| August 08, 2007 16:49:51 |
#1 |
| Raghu |
Member Since: Visitor Total Comments: N/A |
RE: How do you load partial data after job failed
|
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 |
| |
Back To Question | |
