SCD in datastage-how to implement?

[karthikgk0705]

Hi all,
I know the basic concepts about Slowly Changing Dimensions.But I get into trouble when I try to put them in real-time in data stage?

Can anyone clearly explain me how to implement SCD in data stage?
(for all three types).

Thank u

[suresh.narasimha]

Hi

Type1 - u can do it by update option insert else update.
Type2 -

LookUpTgt
i
i
i

source---->Transformer-------------->Target(3 links to target)

Generate Surrogate Key in Transformer.
Lookup the target and compare the key feild and changing column write constraints accordingly to 3 links. One for NewInsert, One for Changed Insert, One for Updating the changed record.
Also, maintain link ordering.

Regards,
Suresh N

[meena]

Hi
You can do a search in the forum based on slowly changing dimesions, we have posts discussed on this.Check this post.
viewtopic.php?t=177