SCD-Strategien (EN)

SCD-Strategies at a glance

SCD-Strategies (Slowly Changing Dimensions) are methods for managing changes in dimension tables over time. The most common strategies are SCD Type 1 (overwrite old values), SCD Type 2 (historization with complete history), and SCD Type 3 (extension with historical value). The choice of the right SCD strategy depends on the requirements of data analysis.

Architecture

flowchart TD     A[Data source] --> B[Dimension table]     B --> C{SCD type}     C -->|Type 1| D[Overwrite]     C -->|Type 2| E[New entry]     C -->|Type 3| F[Extend]     D --> G[Updated dimension]     E --> H[Historized dimension]     F --> I[Extended dimension]     G --> J[Fact table]     H --> J     I --> J 

In context

• Typically used together with Data Warehousing and ETL processes
• Related to: Dimension tables, Data Vault, Kimball model
• Example use: Tracking customer address changes over time