GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing

 Print  |  
Question:  What is the main difference between star and snowflake star schema? Which one is better and why?



February 02, 2007 02:30:07 #3
 jyothi   Member Since: Visitor    Total Comments: N/A 

RE: What is the main difference between star and snowf...
 
Star Schema does not provide any means of normalization but Snow Flak Schema do provide the normalization. It is good to use the table with normalization so its good to use snow flak rather than star schema
     

 

Back To Question