Data Warehousing Basics Question:

Explain degenerate dimension table?

Basics Data Warehouse Interview Question
Basics Data Warehouse Interview Question

Answer:

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


Previous QuestionNext Question
Explain What are the possible data marts in Retail sales?Explain hybrid slowly changing dimension?