History Erased

A medium AI Coding interview practice problem on DataDriven. Write and execute real ai coding code with instant grading.

Domain

AI Coding

Difficulty

medium

Seniority

L5

Problem

dim_customer is supposed to be SCD-2: every change to address/email creates a new row with effective_from / effective_to and is_current. After today's incremental run, the table has exactly one row per customer , history wiped. Run tests/test_scd2_history.py to reproduce. Fix sql/merge_dim_customer.sql so changes append a new version and close the old one, instead of overwriting.

Summary

Yesterday never happened.

Practice This Problem

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