How do you implement SCD type 2 in datastage ?

Interview Candidate
Mar 22nd, 2015
3
8951

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

Murali

Jun 2nd, 2015

SCD type 2 can be implemented by adding Surrogate Key. The existing Primary Key will be considered as a Natural Primary Key and the Surrogate Key will be your Primary Key.Also, Start date & End date (or) Version Number should be created to capture the history of the customer. In SCD type 2 only rows will be inserted whereas in SCD type 3 new columns will be created. Hope this helps a bit.