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
-->

Junk dimension

A separate dimension table to group combinations of indicators and flags with low cardinality to avoid a monster star scheme and poor performance. A junk dimension is a composite of a number of small dimensions that exist for the purpose of decoding operational codes. In a situation where there are many such small dimensions, it is possible to merge them into one junk dimension. The big advantage of this is that it reduces the number of foreign keys in the fact table.

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