Can you explain the star schema for OLAP
Q
What are fact tables and dimension tables in OLAP ?
✍: Guest
A
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, 5530👍, 0💬
Related Topics:
What is the use of OLAP
What is the use of OLAP ? OLAP is useful because it provides fast and interactive access to aggregated data and the ability to drill down to detail. 2007-10-25, 5469👍, 0💬