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 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.
  5. Old_rec also will come to update_strategy condition will given dd_insert then will send to target.