Showing posts with label what is junk dimension? what is the difference between junk dimension and degenerated dimension?. Show all posts
Showing posts with label what is junk dimension? what is the difference between junk dimension and degenerated dimension?. Show all posts

Saturday, May 4, 2013

what is junk dimension? what is the difference between junk dimension and degenerated dimension?


Junk dimension: Grouping of Random flags and text Attributes in a dimension and moving them to a separate sub dimension.

Degenerate Dimension: Keeping the control information on Fact table ex: Consider a Dimension table with fields like order number and order line number and have 1:1 relationship with Fact table, In this case this dimension is removed and the order information will be directly stored in a Fact table inorder eliminate unneccessary joins while retrieving order information..