Question
When processing a Type 2 dimension change, what must the ETL process do?
Select an option. Your answer will be checked instantly.
Correct Answer: D. Expire the old version and insert a new row with a new surrogate key
Explanation:
Type 2 preserves both old and new attribute states as separate dimension rows.
Effective dates or current flags identify when each version applies.
Leave a Reply