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
Implementing scd-1 and scd-2
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 92
- Joined: Mon May 07, 2007 4:26 am
-
- Premium Member
- Posts: 41
- Joined: Tue Jul 08, 2008 5:45 am
- Location: Columbus
Re: Implementing scd-1 and scd-2
Yes Of course. You can develop a scd 1 and scd 2 in server edition.
Using OCI stage you have to deveop a source view and a deleted view(Which is target minus source in order to get deleted records).
You have to add indicator flag which says whether it is current record or updated or deleted. And obviously you have run that job in incremental for capturing history....
Using OCI stage you have to deveop a source view and a deleted view(Which is target minus source in order to get deleted records).
You have to add indicator flag which says whether it is current record or updated or deleted. And obviously you have run that job in incremental for capturing history....
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Did you Search DSXchange?
You can also take IBM's Advanced DataStage (server edition) class, which explains the process in detail.
You can also take IBM's Advanced DataStage (server edition) class, which explains the process in detail.
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.