In a star schema, a fact table typically contains the measures and foreign keys to the _______ tables.

  • Aggregate
  • Dimension
  • Fact
  • Primary
In a star schema, the fact table contains the measures (quantitative data) and foreign keys that connect to dimension tables. Dimension tables hold descriptive information about the data, so the foreign keys in the fact table point to the dimension tables, allowing you to analyze the measures in context.
Add your answer
Loading...

Leave a comment

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