Data Modeling & Warehousing Fundamentals
Back to Dimensional Modeling in Practice

Quiz: Dimension Design Patterns

Three named patterns: conformed (shared dimensions), junk (catch-all flags), role-playing (same dimension wearing different hats).

7 minutesInteractive tutorial
🎯 Free Guest Mode: You are learning for free. Sign in to save your completion progress and quiz answers.
Question 1 of 9Answer saved0 answered

Marketing's fact has `customer_tier`. Finance's fact has `customer_grade`. Both are computed from the same source data but disagree on what 'high-value' means. What's the right fix?

← Back to Dimensions — Conformed, Junk, and Role-Playing