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
SCD in datastage-how to implement?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 45
- Joined: Tue Aug 29, 2006 2:59 am
- Location: Bangalore
-
- Premium Member
- Posts: 81
- Joined: Mon Nov 21, 2005 4:17 am
- Location: Sydney, Australia
- Contact:
SCD in datastage
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
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
SURESH NARASIMHA
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
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