Dimension attributes change. How you handle this matters.
Type : Overwrite Replace old value. Lose history. Use when history doesn't matter.
Type : Add new row New row with version dates. Preserves full history. Most common.
Type : Add column Store current and previous value. Limited history.
Type implementation:
| customer_id | name | valid_from | valid_to | is_current | | | John Smith | -- | -- | false | | | John Doe | -- | -- | true |
Interview favorite: "How would you handle a customer changing their address?"