medium10 pts · first answer countsscddata-modeling

Keeping just the previous value

The sales team is being reorganised. Reports must show each rep under both the current region and the region they had just before the change, but deeper history is not needed. Which SCD type fits?

A.Type 3: add a previous_region column next to current_regionB.Type 1: overwrite the regionC.Type 0: never change the regionD.Type 2: add a new row for every change

Discussion 0

Join free to post in the discussion.

Keeping just the previous value

Discussion 0

Related questions