When Two Fact Tables Need the Same Dimension

Concepts covered: dmStarSchema

What They're Really Testing The Problem: Non-Conformed Dimensions Cite this in your answer: 'At a ride-sharing company, operations defined active driver as completed-a-ride-in-30-days. Finance defined it as has-a-valid-payment-method. The CEO asked how many active drivers we have and got two different numbers. Neither was wrong. Both were right within their own definition. The warehouse had no way to produce one answer.' This is the problem conformed dimensions solve. Tell this story in 15 seconds. The Fix: One Dimension, One Definition The strong-hire sentence: 'Conformed dimensions are what let you drill across fact tables. Without them, each fact table is an island and cross-domain analysis requires brittle ad-hoc joins on natural keys with inconsistent definitions.' The 60-Second Frame

About This Interactive Section

This section is part of the Conformed and Role-Playing Dimensions: 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.