| |
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 |
| January 01, 2006 02:55:52 |
#5 |
| Sithu |
Database Expert Member Since: December 2005 Total Comments: 161 |
RE: What Snow Flake Schema
|
Star schema A single fact table with N number of Dimension Snowflake schema Any dimensions with extended dimensions are know as snowflake schema Multiple Star (galaxy) If the schema has more than one fact table then the schema is said to be Multiple star Cheers, Sithu |
| |
Back To Question | |
