Degenerate Dimension

by Amol 19. February 2011 11:12


Degenerate Dimension:

Degenerate Dimension is a dimension which is derived from the fact table and doesn't have its own dimension table.

Degenerate Dimension can be described in other words as

  • A degenerate dimension is data that is dimensional in nature but stored in a fact table.
  • Any Dimension keys that are not joined to dimension table are considered as degenerate dimension.
  • Degeneratate dimension when dimension keys are part fact table without having dimension.

For examle :

Order Number, Receipt Number, Bill Number are the degenerate dimension as they are part of trasaction fact table without having dimension attached to it.


Tags: ,


Tag cloud