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   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories >> Software >> Data-Warehouse >> Data-Warehouse-General
 
 
 
Question
Hi,

Could any one tell me which schema (star and snow flake 
schema) will take much space?

Thanks
S.A.K
 Question Submitted By :: Ashakamuri
I also faced this Question!!     Rank Answer Posted By  
 
Answer
Star flake schema will take more space than snow flake 
schema.
Snow flake schema approach increases the number of joins 
and results poor performance in data retrieval. In few 
organizations, they try to normalize the dimension tables 
to save space.

keke...
 
0
Kranthi.kunta
 
View All Answers
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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