Data Warehousing Basics Question:
Download Job Interview Questions and Answers 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
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 Question | Next Question |
| Explain What are the possible data marts in Retail sales? | Explain hybrid slowly changing dimension? |