Hi,
Can anyone help me in implementing SCD type2 in Data stage version 8
Regards
Sasi
SCD type 2
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
There is a Slowly Changing Dimension stage that does all of the hard work for you.
You do need to have set up a surrogate key generator of some kind.
Read the documentation for the SCD stage, browse DSXchange for more information, and then post any specific questions that you have.
There is a Slowly Changing Dimension stage that does all of the hard work for you.
You do need to have set up a surrogate key generator of some kind.
Read the documentation for the SCD stage, browse DSXchange for more information, and then post any specific questions that you have.
The other answer is "yes, in exchange for a consultancy fee".sasi_ds wrote:Can anyone help me in implementing SCD type2 in Data stage version 8
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.
Re: SCD type 2
Yes, we cansasi_ds wrote:Hi,
Can anyone help me in implementing SCD type2 in Data stage version 8
Regards
Sasi
![Razz :P](./images/smilies/icon_razz.gif)
Re: SCD type 2
Yes, we cansasi_ds wrote:Hi,
Can anyone help me in implementing SCD type2 in Data stage version 8
Regards
Sasi
![Razz :P](./images/smilies/icon_razz.gif)