A SaaS company has Salesforce CRM and Stripe payments feeding two parallel paths: a Finance ETL that

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

A SaaS company has Salesforce CRM and Stripe payments feeding two parallel paths: a Finance ETL that joins them one way and a Marketing ETL that joins them differently, each writing its own fact table. Every Monday the CFO and the head of marketing report different totals. Apply the section's fan-in framing so the two sources join exactly once into one canonical fact table that both dashboards read from.

Practice This Problem

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