Degenerate Dimension - nkreimer/BI GitHub Wiki
Degenerate Dimension
- Stored in Fact Table
- Dimension Key
- Not a Fact or an Attribute
- Has no related dimension, is a key without a related dimension
- Provides grouping
| FK_OrderDate | FK_Product | DD_OrderID | Quantity | Amount |
|---|---|---|---|---|
| 20130508 | 455 | 152 | 6 | 52.45 |
| 20130508 | 213 | 152 | 1 | 12.44 |
| 20130508 | 211 | 152 | 2 | 83.82 |
| 20130508 | 321 | 128 | 8 | 9.54 |
| 20130508 | 751 | 128 | 4 | 16.22 |