What Snow Flake Schema

Q&A Categories

Applications
Business-Objects
Clarify-CRM
- AJAX
- CSS
- CSS3
- Html
- java-Script
- VB-Script
Concepts
- Data-Modeling
- Data-Structures
- OLAP
- OOPS
- UML
Data-Warehouse
- Abinitio
- Analysis-services
- Business-Intelligence
- Cognos
- Concepts-and-Architecture
- Data-Warehouse-General
- DataStage
- Designer
- ETL
- Informatica
- MicroStrategy
- Reportnet
Database
- Btrieve
- Database-Admin
- Firebird
- Informix
- Microsoft-Access
- MYSQL
- PostgreSQL
- SAP-DB
- SQL
- SQL-server-2000-interview-questions
- Stored-Procedures
- Sybase
- Unify
General
- Career-Goals
- Creativity
- Flexibility
- Human-Resources
- Interests
- Job-Peformance
- Leadership
- Motivation
- Personal-Interview
- Self-Assessment
- Skills
Help-Desk
J2EE
- Core-Java
- EJB
- Hibernate
- Java
- Java-Patterns
- JDBC
- JMS
- JSP
- Ruby
- Servlets
- Struts
- Websphere
Languages
Mainframe
- CICS
- COBOL
- DB2
- IDMS
- JCL
- VSAM
Management
- Business-Analyst
- Citrix
- Desktops
- Lotus-Notes
- MBA
- Network
- Project-Manager
- Servers
- Team-Lead
Microsoft
- Ado-NET
- Architecture
- ASP
- ASP-NET
- Basics
- C-Sharp
- DataGrid
- DotNet
- Mixed
- VB-NET
- Visual-Basic
Microsoft-NET
Networking
- Bluetooth
- Client-Server-Computing
- Computer-Networks
- Networks-and-Security
Operating-System
- Shell-Scripting
- Solaris-Admin
- UNIX
- Unix-Commands
- Unix-Programming
- Windows-Unix
Oracle
- Backup-and-Recovery
- D2K
- Data-Access
- Database-Administration
- Database-security
- Distributed-Processing
- Memory-Management
- Oracle-Forms-3-0
- Oracle-Forms-4-0
- Oracle-General
- PL-SQL
- Programmatic-Constructs
- RMAN
- Scenarios
- SQL-Plus
- System-Architecture
Oracle-Apps
- Application-Object-Library
- Component-Interface
- Flexfields
- Forms-Customization
- HRMS
- PeopleCode
- PeopleTools
- PS-Admin
- PS-Mixed
- Scope-and-Application
- Segment-Security
- SQR
- Technical
- test
Peoplesoft
Programming
- Alogirthms
- C
- C-Plus-Plus
- ColdFusion
- Delphi
- Perl
- PHP
- Python
- VBA
- VoiceXML
- XML
SAP-R-3
- ABAP
- BDC
- Internal-Tables
- Modules
- Reports
- SAP-Admin
- sd
Siebel
- Siebel-General
Testing
- Bug-Tracking
- Common
- Common-Questions
- DataBase-Testing
- Discussion
- Load-Testing
- Product-Testing
- QA-Testing
- Quality-Control
- Quality-Management-
- Security-Testing
- Software-Testing
- Test-Automation
- Test-Cases
- Testing-General
- Testing-Scenarios
- Web-Testing
- Whitebox-Testing
- Wireless-Testiing
Testing-Tools
- LoadRunner
- QTP
- Rational-Robot
- SilkTest
- Test-Director
- Winrunner
Web
Accounting-Reports
Accounts-Payable
Accounts-Receivables
Audit
Cashier
Cost-Accounting
Fixed-Assets
General-Ledger
Payroll
Supervisory

Sep

2010

What Snow Flake Schema 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’