Hi,
How to handle the situation if a job fails in full refresh? I mean in full refresh first it is going to truncate table and then it will start insert new records. If there is any primary key violation or some other error might causes to fail that job then at that time target would be ended up with no data. I want to have atleast previous data (before truncating).
Thanks,
How to handle full refresh situation if job fails?
Moderators: chulett, rschirm, roy
DataStage won't backup data for you if you choose to truncate your target table. An alternative would be to rename the original table in before-SQL, let DataStage create a new target-table for you. This way you can cleanup easily in case of errors at the cost of keeping a renamed copy of your original data at least until the current load has finished successfully.
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon