Project Management Answers

What type of schema consists of one fact table that references any number of dimension tables?

Q: What type of schema consists of one fact table that references any number of dimension tables?

or

Q: One fact table that refers any number of dimension tables is what kind of schema is it?

  • Snowflake
  • StarĀ 
  • Dimensional
  • Relational

Explanation: The schema that consists of one fact table that references any number of dimension tables is the Star schema. In a star schema, the fact table is at the center and is connected to multiple dimension tables, resembling a star shape.

Leave a Reply

Your email address will not be published. Required fields are marked *