Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want this answer help me
hi
Star schema vs Snowflake schema face off is the performance of these models.
The Snowflake model has higher number of joins between dimension table and then again the fact table and hence the performance is slower.
The Star model on the other hand has lesser joins between dimensions tables and the facts table.
hope this helps you.
Regards
Santosh,
Are these interview questions? It looks like you're asking all the interview questions.
Cheers,
DV
www.QlikShare.com
You can get best out of QlikView with Star Schema in terms of performance and resource consumption.
Snowflake in a RDBMS gives advantage of savings some disk space since dimensions are normalized.
QlikView does not store duplicates anyways, so snowflake is not a recommended approach.
Santosh, would love to answer all your questions but have to say that if you check on Community you will get the same answer being asked and answered so many times....
It is just a bit search, little work around and you will get your answer without waiting for someone to answer...
Hope this will make clear to you..
Thanks and Regards,
Manish Kachhia