Incremental CDC deltas arrive, but the warehouse table is append-only, so an updated order shows up

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

Incremental CDC deltas arrive, but the warehouse table is append-only, so an updated order shows up as two rows and downstream counts are wrong. Design the load so an update replaces the prior version instead of duplicating it.

Practice This Problem

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