Hi all,
I'm having three different source tables.In that daily insert update and delete operations takes place.i have to capture these changes
into a single target table.For some tables i'm using SCD-1.and for SCD-2.
So how can i achieve that.
Thanks in advance
How to handle SCD-1 and SCD-2 ?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 92
- Joined: Mon May 07, 2007 4:26 am
Re: How to handle SCD-1 and SCD-2 ?
creating a trigger will help but depending upon your transactions for insert,upate and delete for number of rows their will be performance issue which you have to check out with your DBA.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are several change capture products that work by "scraping" the transaction logs. You might like to investigate these.
Otherwise you need a "before image" of the table before any of the insert, update or delete operations has been applied, and some way to compare the new with the old. That, at least, can readily be done using DataStage.
Otherwise you need a "before image" of the table before any of the insert, update or delete operations has been applied, and some way to compare the new with the old. That, at least, can readily be done using DataStage.
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.