Data Literacy Geek
Navigation
  • Home
  • The Geeks
  • Insightclopedia
  • Blog
  • Search
  • Home
  • The Geeks
  • Insightclopedia
  • Blog
  • Search
A B C D E F G H I J K L M N O P Q R S T U V W X Z
-->

Degenerated dimension

A degenerate dimension is a dimension that is included in the fact table. It is a virtual dimension, without its own physical dimensional table. It does not refer to a dimension and is not a measure. Example: order number. All sales are linked to order number. There are several order lines on 1 order. Via order you can find all kinds of information (customer, seller, etc.). However, these are already linked via the dimensions to the fact table. The added value of the order number is gone. After all, you can find them via customer, but a customer can also have multiple orders. There is only 1 place left, the fact table, only serves to find everything from 1 order together.

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OK