Q : What is Snowflake Schema in SSAS ?
A Snowflake Schema contains fact table and dimension tables,
with the fact table storing facts about business transactions and some columns of the fact containing
foreign key references to the dimension tables. The dimension tables of a
snowflake schema are typically normalized to the third normal form (3 NF) or
higher. As a result the data for a given dimension is spread out over multiple
tables, and a diagram of the database resembles a snowflake.
No comments:
Post a Comment