Data Architect Interview Question:

Tell us what is degenerated dimension?

Submitted by: Muhammad

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.
Submitted by: Muhammad