Advanced Dimensional PatternsQuick Decisionadvanced5 min

Outrigger dimensions

Decide when one dimension may reference another (an outrigger) versus over-snowflaking.

How this preview works

Preview this problem before signing in. Sign in to save progress and submit work.

Concept

dimensional-modeling-basics

The primary modeling idea this problem reinforces.

Requirements

Business needs the model must satisfy.

Scenario

A store dimension needs demographic attributes for the store’s county that are themselves a slowly maintained, reused set. The team debates embedding the county demographics directly on the store dimension or referencing a shared demographics dimension as an outrigger.

Why this matters

An outrigger is a dimension referenced by another dimension. Used sparingly for a reused, independently maintained attribute cluster it is fine; used everywhere it snowflakes the model and hurts usability.

Requirements

Pick the outrigger decision that balances reuse against usability.

What success looks like

The answer uses an outrigger only for the reused, independently maintained cluster.
The explanation warns against general snowflaking.

Hints

An outrigger is a dimension referenced by another dimension.
Reserve it for a reused, separately maintained attribute cluster.

Common pitfalls

Snowflaking every dimension attribute into outriggers.
Copying the reused demographics onto every dimension that needs them.
Treating outriggers as always-bad or always-good rather than situational.

Reference approaches

These are valid approaches, not one absolute answer.

Sparing use of an outrigger dimension

Reference a shared demographics dimension from the store dimension only because it is a reused, independently maintained cluster. Do not snowflake ordinary attributes this way. That restraint is what makes it a Kimball outrigger.

Optimizes for

• Reuse of a maintained attribute cluster
• Avoiding duplicated demographics

Trade-offs

• Adds a join behind the dimension
• Overuse snowflakes and hurts usability

In this set

Problem 6 of 6 in Advanced Dimensional Patterns.

Your progress

Saved learner intelligence from this challenge loop.

Not started

Submit your answer

Pick an answer and submit to see whether you were right. Create an account when you want your progress saved.

How should the reused county demographics relate to the store dimension?Reference a shared demographics dimension as an outrigger, used sparingly.Snowflake every store attribute into its own table.Copy the demographics onto every store row.

You can submit and see the answer now. Create an account to save your progress and track attempts.

Try the question first.

The discussion has other people's approaches and solutions. Give it a real attempt before you read them.