Data Warehousing Basics Interview Question:

Explain degenerate dimension table?

Submitted by: Administrator

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
Submitted by: Administrator