Home > Software > QlikView
Interview Questions   Tutorials   Discussions   Programs   Videos   

QlikView - Difference between star schema and snow flake schema?




1078
views
asked SRVMTrainings July 2, 2014 12:45 PM  

Difference between star schema and snow flake schema?


           

1 Answers



 
answered By SRVMTrainings   0  
Star Schema: In a star schema, the fact table will be at centre and in connected to dimensional tables. The tables are completely in Denormalized Structure. SQL queries performance in good as there are less number of joins involved. Data redundancy is high and occupies more disk spaces. Snowflake Schema: is an extension of star schema where the dimension tables are further connected to one or more dimensions. The tables are partially denormalized in structure. The performance of SQL queries is little bit less compared to star schema as more no. of joins are involved. Data redundancy is low and occupies less disk space compared to star schema.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert