When Two Fact Tables Need the Same Dimension

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