Problem with SCD type 2
Posted: Mon Nov 24, 2008 5:13 am
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.