Data Warehousing Basics Question:

Explain degenerate dimension table?

Tweet Share WhatsApp

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 PDF Read All 37 Basics Data Warehouse Questions
Previous QuestionNext Question
Explain What are the possible data marts in Retail sales?Explain hybrid slowly changing dimension?