| |
GeekInterview.com > Tech FAQs > DataStage
| Print | |
Question: If a DataStage job has aborted after say 1000 records, how to continue the load from 1000th record after fixing the error?
|
| May 05, 2007 05:42:28 |
#3 |
| baglasumit21 |
Member Since: Visitor Total Comments: N/A |
RE: If a DataStage job has aborted after say 1000 reco...
|
It is not possible to start loading the rows after 1000th row. but there are many ways you can achieve it.
1) If the target table has current timestamp as a column then we can delete the rows having max timestamp and load all the rows from start.
2) We can perform a look-up of source table with the target table to check if the rows exist in target table and insert only the non-existing rows. |
| |
Back To Question | |
