| |
GeekInterview.com > Interview Questions > Data Warehousing > Basics
| Print | |
Question: what is junk dimension?
what is the difference between junk dimension and degenerated dimension?
|
| July 07, 2006 04:46:07 |
#4 |
| |
Member Since: Visitor Total Comments: N/A |
RE: what is junk dimension?what is the differenc...
|
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.. |
| |
Back To Question | |
