SCD type 2

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sasi_ds
Participant
Posts: 1
Joined: Mon Feb 25, 2008 12:24 am
Location: chennai

SCD type 2

Post by sasi_ds »

Hi,

Can anyone help me in implementing SCD type2 in Data stage version 8

Regards
Sasi
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.

sasi_ds wrote:Can anyone help me in implementing SCD type2 in Data stage version 8
The other answer is "yes, in exchange for a consultancy fee".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
prabu
Participant
Posts: 146
Joined: Fri Oct 22, 2004 9:12 am

Re: SCD type 2

Post by prabu »

sasi_ds wrote:Hi,
Can anyone help me in implementing SCD type2 in Data stage version 8
Regards
Sasi
Yes, we can :P
prabu
Participant
Posts: 146
Joined: Fri Oct 22, 2004 9:12 am

Re: SCD type 2

Post by prabu »

sasi_ds wrote:Hi,
Can anyone help me in implementing SCD type2 in Data stage version 8
Regards
Sasi
Yes, we can :P . hope this answers your question
Post Reply