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