In SCD Type3 ,there should be added two column to identifying a single attribute. It stores one time historical data with current data
- This is the source
- This is the entire mapping
- Up to rouer transformation ,all the procedure is same as described in Scenario_36 SCD type1.
- 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.
- For old_rec send to update_strategy and set condition dd_insert and send to target.
- You can create one effective_date column in old_rec table