In a star schema, what is the role of a fact table?

SQL Data Analyst Hard

SQL Data Analyst — Hard

In a star schema, what is the role of a fact table?

Key points

  • Fact tables hold numerical data and links to dimensions
  • They enable analysis across different dimensions
  • Fact tables do not store descriptive attributes about business entities
  • They do not enforce referential integrity between dimension tables

Ready to go further?

Related questions