Dataload into Multi Table

oacvb · Post by **oacvb** » Wed Sep 15, 2010 8:48 am

I have 7 jobs that extracts data from 7 db2 tables and loads into respective 7 SQL Server tables at target in a batch mode, all 7 jobs will be called in 15 minutes interval. All 7 tables doesn't have metadata column to identify the data load for any batch. Challenge is if any one of the job is failed we need to roll back from all the 7 tables. Is there any way we can roll back from all the 7 tables?

ray.wurlod · Post by **ray.wurlod** » Wed Sep 15, 2010 5:15 pm

No. Once you've committed, you've committed. Your data will need to carry some kind of run identification that you can use in "cleanup" jobs to delete those rows. Life gets trickier if you have updates, but you have not mentioned those.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 15, 2010 5:16 pm

Moderator: please move to Enterprise Edition (parallel) forum

This is not a QualityStage question.

chulett · Post by **chulett** » Wed Sep 15, 2010 6:29 pm

Unfortunately, this forum is not moderated.