How to handle full refresh situation if job fails?
Posted: Mon Dec 03, 2012 9:49 am
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 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,