How to handle SCD-1 and SCD-2 ?

[sureshchandra]

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

[sachin1]

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.

[ray.wurlod]

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.