Snowflake Schema in data warehouse

Posted on | January 11, 2010 | No Comments

A Snowflake schema has a centralized fact table surrounded by dimension tables.The dimension table in snow flake schema are normalized.There will be single fact table joined to multiple dimension table which in turn may be joined to other dimension tables.So snowflake schema has following features

1. Large number of dimension tables.
2. Since dimension table are normalized the size of dimension table is small
3. For query purpose we need to retrieve data from multiple dimension table resulting in more joins and slower performance.

Please leave your comment and feedback in below form to improve the site

Comments

Recent Posts

• Star Schema in Data Warehouse
• grep command in unix with example
• File Compression and archival in UNIX
• Snowflake Schema in data warehouse
• ETL tools in data warehousing?

Archives

• February 2010
• January 2010
• December 2009

Categories

• Basic Concepts in Data Warehousing
• UNIX in Data Warehousing