# A SaaS company has Salesforce CRM and Stripe payments feeding two parallel paths: a Finance ETL that Canonical URL: 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. ## Related - [All practice problems](https://datadriven.io/problems) - [Mock interview mode](https://datadriven.io/interview/a-saas-company-has-salesforce-crm-and-stripe-payments-feedin-1e2395b9) - [System Design Interview Questions](https://datadriven.io/data-engineering-system-design) - [Data Engineering Interview Prep Guide](https://datadriven.io/data-engineer-interview-prep) - [Daily Challenge](https://datadriven.io/daily) --- Source: DataDriven (https://datadriven.io). 100% free data engineering interview prep. Live code execution against Postgres 16, Python 3.11, and Spark sandboxes. No paywall, no premium tier, no signup gate.