Skip to Content
0
Former Member
Dec 14, 2011 at 03:46 AM

"recover as a unit" and delta extractors

37 Views

We are in the process of designing our job recovery and one thing that is a little unclear is what will happen with Delta queues when a job falls over.

If I have 3 delta dataflows in a workflow labelled as "recover as a unit" does this mean if the 3rd one fails, all 3 delta queues will reset back to before the job ran ?

What happens to destination tables ? Are the rolled back ? if my delta applies an insert when it is re-run that had already been applied, won't it just fail due to duplicates ?

Any recommendations / best practice in this area is appreciated.

Thanks,

Leigh.