MSBI (SSIS/SSRS/SSAS) Online Training

Thursday, March 19, 2009

SSAS-JUNK DIMENSION

Hi,
Here am explaining the junk dimension.
A number of very small dimensions might be lumped together to form a single dimension, a junk dimension - the attributes are not closely related. Grouping of Random flags and text Attributes in a dimension and moving them to a separate sub dimension is known as junk dimension.
http://sqlblog.com/blogs/marco_russo/archive/2007/09/02/datetool-dimension-an-alternative-time-intelligence-implementation.aspx

2 comments:

GopiK said...

It helps. Thanks

soumya said...

Great Information you have shared with us. Thanks for providing check it once through MSBI Online Training Bangalore