What does a Type 2 slowly changing dimension do?
- A Inserts a new row with effective dates, preserving full history
- B Overwrites the existing value
- C Deletes the old record
- D Stores changes in a separate log only
Answer
Inserts a new row with effective dates, preserving full history
Type 2 is what allows a sale to be attributed to the customer's region at the time of the sale rather than their current region.





