In SCD Type3 ,there should be added two column to identifying a single attribute. It stores one time historical data with current data

  1. This is the source
  2. This is the entire mapping
  3. Up to rouer transformation ,all the procedure is same as described in Scenario_36 SCD type1.
  4. The only difference is after router bring the new_rec to router and give condition dd_insert send to  target. Create one new primary key send to target.
  5. For old_rec send to update_strategy and set condition dd_insert and send to target.
  6. You can create one effective_date column in old_rec table