Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - If a DataStage job aborts after say 1000 records, how to continue the job from 1000th record after fixing the error?




980
views
asked Rams September 6, 2014 01:22 AM  

If a DataStage job aborts after say 1000 records, how to continue the job from 1000th record after fixing the error?


           

1 Answers



 
answered By vishnoiprem   0  

Method 1:

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.

method 2:

By specifying Checkpointing in job sequence properties, if we restart the job. Then job will start by skipping upto the failed record.this option is available in 7.5 edition.

flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert