Put it all together: keep a warehouse customer dimension fresh from an operational DB

A medium Pipeline Design interview practice problem on DataDriven. Write and execute real pipeline design code with instant grading.

Domain

Pipeline Design

Difficulty

medium

Problem

Put it all together: keep a warehouse customer dimension fresh from an operational DB. Move only changed rows via CDC, preserve attribute history (SCD2), let the schema evolve when a new column appears, and support backfilling a corrected partition without a full reload.

Practice This Problem

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