All,
I have created some test jobs for change capture and change apply stages. It works fine. But i just used some dummy data to get familiar with these 2 stages. I am eager to know where exactly these two stages will help the business. is it possible to give some real life usage of these 2 stages?
Inputs are welcome!
change capture & change apply
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
change capture & change apply
Karthik
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Detecting changes is a very common requirement, particularly when handling slowly changing dimensions.
The ability to re-build a data set from a before-image and captured change data is important in recovery situations.
The ability to re-build a data set from a before-image and captured change data is important in recovery situations.
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.
Imagine an unfriendly data source that is unable to provide you only the delta records each day or each week. You could extract all the records, possibly even quickly, from the source.
Then use the Change Capture stage to detect the delta records. You can insert/update/delete the target database with only the deltas, saving lots of time.
Then use the Change Capture stage to detect the delta records. You can insert/update/delete the target database with only the deltas, saving lots of time.
Choose a job you love, and you will never have to work a day in your life. - Confucius