Can you explain the star schema for OLAP


What are fact tables and dimension tables in OLAP ?

✍: Guest


The dimensions and measures are physically represented by a star schema. Dimension tables revolve around fact table. A fact table contains a column for each measure as well as a column for each dimension. Each dimension column has a foreign-key relationship to the related dimension table, and the dimension columns taken together are the key to the fact table.

2007-10-25, 4785👍, 0💬