What is Slowly Changing Dimensions?

Slowly Changing Dimensions (SCDs) are a database design technique used in data warehousing to manage the changes to dimension table attributes over time. Instead of overwriting existing data with new data, SCDs preserve historical data, allowing for analysis of how data has changed over time. They are commonly used to track changes in customer demographics, product information, or organizational hierarchies.