02-dimension-patterns

What problem does it solve?

This Skill addresses the complexity of designing robust and efficient dimension tables in a data warehouse by providing patterns for various scenarios, preventing common modeling pitfalls.

Core Features & Use Cases

• Dimension Pattern Selection: Guides users on choosing the right pattern (role-playing, degenerate, junk, mini, outrigger, denormalized hierarchies) based on specific needs.
• NULL Handling: Enforces best practices for handling NULLs in dimensions by using dedicated "Unknown" member rows.
• Flag Management: Ensures low-cardinality flags are stored as textual attributes for better BI readability.
• Use Case: When designing a dim_product table, this skill helps decide whether to flatten brand information directly or use an outrigger, and how to handle product types with vastly different attributes.

Quick Start

Apply the dimension design patterns to create a robust gold layer dimension table.