Saturday, May 4, 2013

Explain degenerate dimension table


Degenerate Dimensions : If a table contains the values, which r neither dimesion nor measures is called degenerate dimensions.Ex : invoice id,empno

Degenerate dimensions are those without any attributes or measures
and they are included inside the fact table
Eg orderno

No comments:

Post a Comment