Implementing scd-1 and scd-2
Posted: Mon Feb 16, 2009 1:42 am
Hi all,
My source is DB2,Which is mirrored into oracle by using Data mirror.For our source DB2 we are not having keys.That is the reason we mirrored into oracle.Now we are having both surrogate key as well as natural key.By using this keys we have to do scd-1 and scd-2 for all the tables.And we have to capture all the changes in the target table.
For example: for 1st table---scd-1,2nd table---scd-2 and 3rd table scd-2. we have to extract all these three tables in a unique target table with changes. we have to capture all the changes happen in the source tables.So is it possible with datastage server edition?If it is yes,please help me how to do?
Thanks in advance
My source is DB2,Which is mirrored into oracle by using Data mirror.For our source DB2 we are not having keys.That is the reason we mirrored into oracle.Now we are having both surrogate key as well as natural key.By using this keys we have to do scd-1 and scd-2 for all the tables.And we have to capture all the changes in the target table.
For example: for 1st table---scd-1,2nd table---scd-2 and 3rd table scd-2. we have to extract all these three tables in a unique target table with changes. we have to capture all the changes happen in the source tables.So is it possible with datastage server edition?If it is yes,please help me how to do?
Thanks in advance