Junk dimension

by Amol 19. February 2011 11:09

 

Junk dimension:

Junk dimension is group of flags which gives us kind of Yes / No or True / False answer. The attributes in junk dimension do not belong to the fact table. Junk dimension contains a unique key to all possible combinations of flags and the generated unique key is used in fact table. 
Junk dimensions are also used for placing attributes like non-generic comments from the fact table. Such attributes might consist of data from an optional comment field when a customer places an order.

 

Tags: ,

Definition

Add comment




  Country flag
biuquote
  • Comment
  • Preview
Loading


Category

Recent Posts

Tag cloud