What is a degenerate dimension in a data warehouse fact table?

SQL Data Analyst Medium

SQL Data Analyst — Medium

What is a degenerate dimension in a data warehouse fact table?

Key points

  • Degenerate dimensions are attributes stored directly in the fact table.
  • They do not have a separate dimension table.
  • Examples include order numbers or invoice numbers.

Ready to go further?

Start full exam Practice more questions

Related questions