easy5 pts · first answer countsdata-pipelinesslowly-changing-dimensions

Keeping the old customer segment

Sales by customer segment must show the segment each customer had at the time of each order, even after segments change. Which dimension design fits?

A.SCD Type 2 with a new row per changeB.SCD Type 1 overwriting the segmentC.Deleting customers who change segmentD.Storing only the latest segment in the fact

Discussion 0

Join free to post in the discussion.

Keeping the old customer segment

Discussion 0

Related questions