The Fan Trap: Joins That Inflate Metrics

Concepts covered: dmGrainDefinition

Your fan trap answer: 'A fan trap happens when I join two facts through a shared dimension and one side has multiple rows per key. The join fans out, duplicating the other side. My SUM now counts revenue 3x because each order was duplicated once per shipment. No error message, no warning, just wrong numbers that look plausible.' Say 'no error message' explicitly. That is what makes fan traps dangerous and why interviewers test them. The Tell: Words That Signal This Pattern The Scenario the Interviewer Will Draw on the Whiteboard The interviewer gives you two tables with different row counts per join key and asks you to combine them. They are not testing your JOIN syntax. They are watching whether you see the fan trap before you write the query. Candidates who join directly and only notice

About This Interactive Section

This section is part of the Grain and Fan Traps: Advanced lesson on DataDriven, a free data engineering interview prep platform. Each section includes explanations, worked examples, and hands-on code challenges that execute in real time. SQL queries run against a live database. Python runs in a sandboxed Docker container. Data modeling problems validate against interactive schema canvases. All content is framed around what data engineering interviewers actually test at companies like Meta, Google, Amazon, Netflix, Stripe, and Databricks.

How DataDriven Lessons Work

DataDriven combines four interview rounds (SQL, Python, Data Modeling, Pipeline Architecture) with adaptive difficulty and spaced repetition. Easy problems get harder as you improve. Weak concepts resurface until you master them. Your readiness score tracks progress across every topic interviewers test. Every lesson section ends with problems you solve by writing and running real code, not by picking multiple-choice answers.