Degenerated Dimension
Ch.02: DWH | DWH Components | Data Modeling | Dimension Types
Lesson Notes
Degenerate Dimension Lesson Notes
Video
Degenerate Dimensions
-
Degenerate Dimensions
-
Dimension Key without corresponding dimension table.
-
Stored in fact table.
-
It used to provide a grouping for business cases.
-
Degenerate Dimensions Example
| OrderID | OrderDate | ProductID | Quantity | Amount |
|---|---|---|---|---|
| 123 | 123456789 | 111 | 2 | 120.45 |
| 123 | 123456789 | 222 | 5 | 10.45 |
| 431 | 98765122 | 333 | 1 | 15.45 |
| 431 | 98765122 | 555 | 6 | 4.45 |
Further Reading
Dimensional Modeling: In a Business Intelligence Environment. The book is free, and you can download it from this link. You can read the below parts for more information about degenerate dimension.
- Chapter 5: Dimensional Model Design Life Cycle Section 5.4.2
- Chapter 6.3.1 Degenerate dimensions page 240