Showing posts with label Explain degenerate dimension table. Show all posts
Showing posts with label Explain degenerate dimension table. Show all posts

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