| |
GeekInterview.com > Interview Questions > Data Warehousing > Basics
| Print | |
Question: What Snow Flake Schema
Answer:
Answered by Girinath.S.V.S on 2005-03-17 06:40:48: Snowflake schemas normalize dimensions to eliminate redundancy. That is, the dimension data has been grouped into multiple tables instead of one large table. For example, a product dimension table in a star schema might be normalized into a products table, a product_category table, and a product_manufacturer table in a snowflake schema. While this saves space, it increases the number of dimension tables and requires more foreign key joins. The result is more complex queries and reduced query performance |
| July 07, 2008 07:51:26 |
#8 |
| harshadapj |
Member Since: July 2008 Total Comments: 2 |
RE: What Snow Flake Schema
|
Closely related to the star schema, the snowflake schema is represented by centralized fact tables which are connected to multiple dimensions
In the snowflake schema, however, dimensions are normalized into multiple related tables whereas the star schema's dimensions are denormalized with each dimension being represented by a single table. |
| |
Back To Question | |
