Your selected language is US English
 
 
 
Skip Navigation Links
Home
Forum Home
Latest 50
Unanswered
All Time Leaders
Jump to CategoryExpand Jump to Category
Login 
    Welcome Guest!
 Search Forum For :  
X
 Login
Please login to submit a new post, reply and edit exiting posts, see user profiles, and access more features. If you are not a registered member, Register here.
User Id / Email:
Password:  
Forgot Password | Forgot UserName
   Home » Data Warehousing » star vs snowflake schemas
       
Author Reply
Alec Stewart
posted 59 posts
since Nov 03, 2011 
from

 star vs snowflake schemas
  Posted on: 12 Jan 2012       
Please tell me the difference between star and snowflake schema?
Sponsored by
Alviro Dan
posted  54 posts
since  Dec 05, 2011 
from 

 Re: star vs snowflake schemas
  Posted on: 16 Jan 2012   Accepted Answer     0  
Hi Alec here is the difference

Star schema
A single fact table with N number of Dimension


Snowflake schema
Any dimensions with extended dimensions are know as snowflake schema
Alec Stewart
posted  59 posts
since  Nov 03, 2011 
from 

 Re: star vs snowflake schemas
  Posted on: 23 Jan 2012        0  
Thanks Alviro
       
Sponsored by
Become a Sponsor
Our recommended articles
Our recommended forum posts
Latest Articles
Understanding DataTypes in MySql
Use of Having clause in MySql
Concept of composite key in MySql
Concepts of Aggregate functions in SQL Server
Concepts of Inner Join, Outer Join, Cross Join And Self Join in SQL Server
To make the column value unique in MySql
Concepts of Search in Stored Procedure With Dynamic Query in SQL Server
How to copy an existing MySql table to a new table with same architecture
Use of Wildcards in MySql
Working with NULL values in MySql
View all »
Latest News
Oracle #1 Database
Download Microsoft SQL Server 2012 Feature Pack
Samsung overtakes Nokia as top mobile maker
Oracle Buys ClearTrial
Google launches monthly user activity feature
View all »
Latest Blogs
LAG and LEAD in SQL Server 2012
How to create sequence in pl/sql
Inbuilt Functions
Description of operators in MySQL
What is the difference between Delete, Truncate and Drop in Oracle
NVL Function in Oracle/PLSQL
Ingmon in Ingres
Normalization in Database
Join Operator in MYSQL
Inbuilt functions in SQL
View all »
Top Articles
Concept of cursor in SQL Server
New Features of SQL Server 2012
Encryption and Decryption of Word Document
Integrated Enterprise Data Warehouse
Adding a Language to MS Word
Concept of Views in Database
Automatic Text Correction in MS Word
PL/SQL FAQ'S
Setting the Privacy Priorities in the MS Word
Concept of Multi-statement table value function in SQL Server
View all »
Free Book Chapters
Getting Your Tools
Chapter 3: How to retrieve data from a single table
Chapter 1: SQL Query Performance Tuning
View all »

 Hosted by MaximumASP  |  Found a broken link?  |  Contact Us  |  Terms & conditions  |  Privacy Policy  |  Site Map  |  Advertise with us
Current Version: 5.2011.3.12
 © 1999 - 2012  Mindcracker LLC. All Rights Reserved