Page 1 of 1
Dataload into Multi Table
Posted: Wed Sep 15, 2010 8:48 am
by oacvb
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?
Posted: Wed Sep 15, 2010 5:15 pm
by ray.wurlod
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.
Posted: Wed Sep 15, 2010 5:16 pm
by ray.wurlod
Moderator: please move to Enterprise Edition (parallel) forum
This is not a QualityStage question.
Posted: Wed Sep 15, 2010 6:29 pm
by chulett
Unfortunately, this forum is not moderated.