ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories >> Software >> Data-Warehouse >> Business-Objects
 
 
 
Question 
what is the difference b/w star and snowflack schema in 
dataware house?
 Question Submitted By :: Zeeshan
I also faced this Question!!     Rank Answer Posted By  
 
Answer
 
Star schema is one fact table in the middle is sorrounded 
by many dimension tables and no extenssion for the dimensin 
table it means denormalized.
Snowflake schema is where the dimension table is extended 
to normalized form
 
0
Thava
 
View All Answers
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com