Data Warehousing Basics Question:
Download Questions PDF

Explain degenerate dimension table?

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

Download Basics Data Warehouse Interview Questions And Answers PDF

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