Dataload into Multi Table
Dataload into Multi Table
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?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: