Data Architect Question:

Tell us what is degenerated dimension?

Tweet Share WhatsApp

Answer:

A degenerated dimension is a dimension that is derived from fact table and does not have its own dimension table.

A dimension key, such as transaction number, receipt number, Invoice number etc. does not have any more associated attributes and hence can not be designed as a dimension table.

Download Data Architect PDF Read All 41 Data Architect Questions
Previous QuestionNext Question
Explain me what do you understand by dimension and attribute?Tell me do you know why Data Warehouse is used?