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.