Data Architect Question:
Tell us what is degenerated dimension?
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.
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.
| Previous Question | Next Question |
| Explain me what do you understand by dimension and attribute? | Tell me do you know why Data Warehouse is used? |