medium10 pts · first answer countsdata-modelingscd

Tracking customer address history

Analysts need to report sales by the customer's city at the time of each order, even after customers move. Which approach fits?

A.SCD Type 1: overwrite the city when it changesB.Delete old customers and reinsert themC.Store only the latest city in the fact tableD.SCD Type 2: add a new row per change with valid_from, valid_to and an is_current flag

Discussion 0

Join free to post in the discussion.

Tracking customer address history

Discussion 0

Related questions