Question

Explain SCD TYPE 3 through mapping.

Answer 1

SCD Type3 Mapping

In SCD Type3, there should be two columns added 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 router transformation, all the procedure is same as described in SCD type1.
4. The only difference is after router, bring the new_rec to router and give condition dd_insert send to.
5. Create one new primary key send to target. 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