Dear All,

I have implemented the External transaction for my sequence container. This has 8 DFTs in it . It is  working fine in case of success or failure.

Now I wanted to implement the solution like if the job stops at the 4th task then first 3 tasks has data in it .

But I wanted to rollback if the job stops in halfway the execution of sequence container. Please help me to solve this issue.

Thank you

Sri

Hi Sri,

Implement a logging mechanism for all the 8 DFT load status. Before starting the all 8 DFT's check for any failure in previous run, in this case, you can truncate data from all the 8  staging table and start a fresh data load.

Hope this helps

Regards,

Vijay