Page 1 of 1

SCD type 2

Posted: Mon Mar 03, 2008 2:04 am
by sasi_ds
Hi,

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

Regards
Sasi

Posted: Mon Mar 03, 2008 2:09 am
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".

Re: SCD type 2

Posted: Sun Jun 29, 2008 10:53 pm
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

Re: SCD type 2

Posted: Sun Jun 29, 2008 10:53 pm
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