Problem with SCD type 2
Moderators: chulett, rschirm, roy
Problem with SCD type 2
I am using SCD stage . My input file is sequential file and reference file is Oracle table(lookup). Dimension update file is dataset. When there is a change in the type 2 column , it is generated the new record with new SK key but not giving the old record that has been expired.Please give me idea how to implement it.
Nirdesh Kumar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: