Sunday, 27 May 2012

What is star schema

Q 1. What is star schema in SSAS ?
A star schema is a type of modeling used as a basis for  building an OLAP cube. It consists of at least one fact table and many dimension tables. The rows in the dimension tables have a 1:M relationship with the rows in the fact table.
In a star schema every dimension table is related directly to the fact table.