Loading...
SCD Type 2 Customer Dimension
A hard Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.
- Domain
- Data Modeling
- Difficulty
- hard
- Seniority
- senior
Problem
Our customer dimension needs to track historical changes to attributes like address, membership tier, and email. When we look at an order from 6 months ago, we need the customer's attributes as of that date, not today's values. Design the schema.
Practice This Problem
Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it instantly.