| |
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 |
| October 10, 2005 01:22:29 |
#2 |
| senthil kumar.B |
CRM Expert Member Since: October 2005 Total Comments: 15 |
RE: What Snow Flake Schema
|
A normalised form of star schema is called snow flake schema. |
| |
Back To Question | |
