Design a hybrid SCD that uses Type 1 for name corrections (overwrite) and Type 2 for address changes

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 hybrid SCD that uses Type 1 for name corrections (overwrite) and Type 2 for address changes (preserve history). Include surrogate key, effective dates, and is_current flag.

Practice This Problem

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