| |
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 |
| December 12, 2005 08:45:04 |
#4 |
| Siva K |
Member Since: Visitor Total Comments: N/A |
RE: What Snow Flake Schema
|
Some people are considering as Normalized star schema, but it is partially normalized star schema. By partially normalizing it we may save some disk space. |
| |
Back To Question | |
