Dimensional Modeling Techniques (DMT): Advanced Patterns for Effective Data Warehouse Design
Conformed Dimensions – Shared dimensions across fact tables
Role-Playing Dimensions – Same dimension used in different contexts
Junk Dimensions – Combining low-cardinality flags
Degenerate Dimensions – Transaction IDs stored in fact tables
Outrigger Dimensions – Secondary dimensions joined to primary dimensions
Bridge Tables – Handling many-to-many relationships
Mini-Dimensions – Managing rapidly changing attributes
