Design a Type 2 SCD customer dimension

A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.

Domain

Data Modeling

Difficulty

medium

Problem

Design a Type 2 SCD customer dimension. Each row version has a surrogate key, the natural key, effective/expiration dates, and an is_current flag. When an address changes, a new row is inserted.

Practice This Problem

Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it automatically.