What is a 'Slowing Changing Dimension' (SCD)?

What is a 'Slowing Changing Dimension' (SCD)?

Approach: Explain handling changes in dimension members over time.

A technique in data warehousing for tracking how attributes in a dimension table change over time. Type 1 overwrites data; Type 2 adds a new row to preserve history.

Follow-up: Which type is used for historical reporting?

Key concepts: scd type 1, scd type 2, versioning.