Logistics company

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

Logistics company. 400 nightly pipelines accumulated over four years. Finance asks for a corrected Q1 revenue figure after a billing-system migration; the audit found duplicates in three of the last 90 partitions of two facts and a customer dimension. 10-Q files in two weeks. Apply the section's five-step synthesis so the affected facts and dimension all land on the right idempotency pattern, the orchestrator drives a 60-day backfill, and the dimension MERGE has a uniqueness check.

Practice This Problem

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