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.
- To identifying new_rec we should and one new_pm and one vesion_no.
- This is the source.
- This is the entire mapping
- All the procedure same as described in 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.
- Old_rec also will come to update_strategy condition will given dd_insert then will send to target.