topic Re: when we go for snowflake scheema model in project? in QlikView https://community.qlik.com/t5/QlikView/when-we-go-for-snowflake-scheema-model-in-project/m-p/691247#M250160 <HTML><HEAD></HEAD><BODY><P>You can get best out of QlikView with Star Schema in terms of performance and resource consumption.</P><P>Snowflake in a RDBMS gives advantage of savings some disk space since dimensions are normalized.</P><P>QlikView does not store duplicates anyways, so snowflake is not a recommended approach.</P></BODY></HTML> Sat, 13 Sep 2014 12:32:18 GMT 2014-09-13T12:32:18Z when we go for snowflake scheema model in project? https://community.qlik.com/t5/QlikView/when-we-go-for-snowflake-scheema-model-in-project/m-p/691244#M250157 <HTML><HEAD></HEAD><BODY><P>i want this answer help me</P></BODY></HTML> Sat, 13 Sep 2014 11:51:24 GMT https://community.qlik.com/t5/QlikView/when-we-go-for-snowflake-scheema-model-in-project/m-p/691244#M250157 2014-09-13T11:51:24Z Re: when we go for snowflake scheema model in project? https://community.qlik.com/t5/QlikView/when-we-go-for-snowflake-scheema-model-in-project/m-p/691245#M250158 <HTML><HEAD></HEAD><BODY><P>hi</P><P><STRONG>Star schema vs Snowflake schema</STRONG> face off is the performance of these models.</P><P><STRONG> The Snowflake model</STRONG> has higher number of joins between dimension table and then again the fact table and hence the performance is slower.</P><P>The Star model on the other hand has lesser joins between dimensions tables and the facts table. </P><P></P><P>hope this helps you.</P><P>Regards</P></BODY></HTML> Sat, 13 Sep 2014 12:09:53 GMT https://community.qlik.com/t5/QlikView/when-we-go-for-snowflake-scheema-model-in-project/m-p/691245#M250158 2014-09-13T12:09:53Z Re: when we go for snowflake scheema model in project? https://community.qlik.com/t5/QlikView/when-we-go-for-snowflake-scheema-model-in-project/m-p/691246#M250159 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Santosh,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Are these interview questions? It looks like you're asking all the interview questions.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Cheers,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">DV</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">www.QlikShare.com</SPAN></P></BODY></HTML> Sat, 13 Sep 2014 12:16:26 GMT https://community.qlik.com/t5/QlikView/when-we-go-for-snowflake-scheema-model-in-project/m-p/691246#M250159 IAMDV 2014-09-13T12:16:26Z Re: when we go for snowflake scheema model in project? https://community.qlik.com/t5/QlikView/when-we-go-for-snowflake-scheema-model-in-project/m-p/691247#M250160 <HTML><HEAD></HEAD><BODY><P>You can get best out of QlikView with Star Schema in terms of performance and resource consumption.</P><P>Snowflake in a RDBMS gives advantage of savings some disk space since dimensions are normalized.</P><P>QlikView does not store duplicates anyways, so snowflake is not a recommended approach.</P></BODY></HTML> Sat, 13 Sep 2014 12:32:18 GMT https://community.qlik.com/t5/QlikView/when-we-go-for-snowflake-scheema-model-in-project/m-p/691247#M250160 2014-09-13T12:32:18Z Re: when we go for snowflake scheema model in project? https://community.qlik.com/t5/QlikView/when-we-go-for-snowflake-scheema-model-in-project/m-p/691248#M250161 <HTML><HEAD></HEAD><BODY><P>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....</P><P></P><P>It is just a bit search, little work around and you will get your answer without waiting for someone to answer...</P><P></P><P>Hope this will make clear to you..</P><P></P><P>Thanks and Regards,</P><P>Manish Kachhia</P></BODY></HTML> Sat, 13 Sep 2014 13:10:12 GMT https://community.qlik.com/t5/QlikView/when-we-go-for-snowflake-scheema-model-in-project/m-p/691248#M250161 MK_QSL 2014-09-13T13:10:12Z