Degenerated Dimension

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

Degenerate Dimensions Example

OrderIDOrderDateProductIDQuantityAmount
1231234567891112120.45
123123456789222510.45
43198765122333115.45
4319876512255564.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