Role Playing Dimension
Ch.02: DWH | DWH Components | Data Modeling | Dimension Types
Lesson Notes
Role-playing Dimension Lesson Notes
Video
Role-Playing Dimension
Role-Playing Dimensions (Re-usable Dimension): A single physical dimension helps to reference multiple times in a fact table as each reference linking to a logically distinct role for the dimension.
Role-Playing Dimension Example
Conformed vs Role-Playing Dimension
-
Conformed is the same dimension used in different facts and has the same meaning ex: CustomerID.
-
Role-Playing is the same dimension which used multiple times within the same fact but with different meanings ex: Date.
Further Reading
- Chapter 6.3.9 Role-playing dimensions page 285 from Dimensional Modeling: In a Business Intelligence Environment. The book is free, and you can download it from this link.