Data Warehousing Interview Question:

What is degenerate dimension table?

Submitted by: Administrator

Degenerate Dimensions: If a table contains the values, which r neither dimension nor measures is called degenerate dimensions. For example invoice id, employee no.A degenerate dimension is data that is dimensional in nature but stored in a fact table.
Submitted by: Administrator