Question

Explain in detail SCD TYPE 2 through mapping.

Answer 1

SCD Type2 Mapping

In Type 2 Slowly Changing Dimension, if one new record is added to the existing table with a new information then, both the original and the new record will be presented having new records with its own primary key.

1. To identifying new_rec we should and one new_pm and one vesion_no.
2. This is the source:
   
3. This is the entire mapping:
   
4. All the procedures are similar to SCD TYPE1 mapping. The Only difference is, from router new_rec will come to one update_strategy and condition will be given dd_insert and one new_pm and version_no will be added before sending to target.
5. Old_rec also will come to update_strategy condition will give dd_insert then will send to target.