Question
A company must report sales using the customer segment that was valid when each sale occurred. Which SCD method is best?
Select an option. Your answer will be checked instantly.
Correct Answer: A. Type 2 historical rows
Explanation:
Type 2 creates a new dimension row with a new surrogate key for each version.
Facts retain the key of the version valid at the event time.
Leave a Reply