We have a new community! Please visit support.timextender.com

What is a degenerate dimension?

A degenerate dimension according to the Ralph Kimball definition, is a dimension key in a fact table that does not have its own dimension table.

It is also sometimes called a fact table dimension.

An order dimension is a common example of a degenerate dimension, as it is based on the order number, order date etc. that exists directly in the fact table. 

Was this article helpful?
0 out of 0 found this helpful


Please sign in to leave a comment.