veer.dwh

 Profile Answers by veer.dwh Questions by veer.dwh

• Sep 23rd, 2009

 

If you are using DS 8.0.1 version, it is very east to implement SCD2 using SCD stage. it supports 2 input links and 2 output links. from the 2 input links. primary Dataset it takes as a current dateset(which has updated information) and 2nd dataset set it will take as refernce table or dementional dateset(which has old data).

Compares these 2 datasets and generate surrogatekey and effective timestamp to store historical date in target. that is taeget. the other o/p link stores updated information(which rows has updated) from the dimentional dataset.

If you are using DS 7.5 version, you have to use change capture stage to denote differnce b/w primary data set and dimentional data set. then you have to use surrogate key stage to pass surrogate key in target table to store the updated information in target.

Thanks,
Veeru.