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.
No comments:
Post a Comment