| |
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 |
| March 03, 2005 06:40:48 |
#1 |
| Girinath.S.V.S |
Member Since: Visitor Total Comments: N/A |
RE: What Snow Flake Schema
|
| 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 |
| |
Back To Question | |
