topic Re: Star Schema or Snow flow Schema in QlikView https://community.qlik.com/t5/QlikView/Star-Schema-or-Snow-flow-Schema/m-p/602275#M1118283 <HTML><HEAD></HEAD><BODY><P>Chek the below link.i hope this helps u alot.</P><P><A href="https://community.qlik.com/message/441803">Star Schema or Snow Flaxe schema?</A></P></BODY></HTML> Tue, 04 Feb 2014 05:25:51 GMT 2014-02-04T05:25:51Z Star Schema or Snow flow Schema https://community.qlik.com/t5/QlikView/Star-Schema-or-Snow-flow-Schema/m-p/602273#M1118281 <HTML><HEAD></HEAD><BODY><H2><SPAN style="color: #ff00ff; font-size: 14pt;">Hi Good Morning....</SPAN></H2><H2></H2><H2><SPAN style="font-size: 14pt; color: #ff00ff;">I have small Confusion between Star Schema and Snow Flow Schema..</SPAN></H2><H2></H2><H2><SPAN style="font-size: 14pt; color: #ff00ff;">Which one is better?</SPAN></H2><H2></H2><H2><SPAN style="font-size: 14pt; color: #ff00ff;">Thanks In Advance....</SPAN></H2></BODY></HTML> Tue, 04 Feb 2014 05:23:34 GMT https://community.qlik.com/t5/QlikView/Star-Schema-or-Snow-flow-Schema/m-p/602273#M1118281 2014-02-04T05:23:34Z Re: Star Schema or Snow flow Schema https://community.qlik.com/t5/QlikView/Star-Schema-or-Snow-flow-Schema/m-p/602274#M1118282 <HTML><HEAD></HEAD><BODY><P>Star schema gives better results especially for qlikview.why because if there is less no of joins qlikview works faster .</P><P></P><P></P><P style="font-size: 12.727272033691406px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">check the below table it will be helpful to u</P><P></P><P style="font-size: 12.727272033691406px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-441882-50885/Untitled.png" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;"><IMG alt="Untitled.png" class="jive-image jiveImage" height="457" src="https://community.qlik.com/legacyfs/online/52534_Untitled.png" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;" width="545" /></A></P></BODY></HTML> Tue, 04 Feb 2014 05:25:11 GMT https://community.qlik.com/t5/QlikView/Star-Schema-or-Snow-flow-Schema/m-p/602274#M1118282 2014-02-04T05:25:11Z Re: Star Schema or Snow flow Schema https://community.qlik.com/t5/QlikView/Star-Schema-or-Snow-flow-Schema/m-p/602275#M1118283 <HTML><HEAD></HEAD><BODY><P>Chek the below link.i hope this helps u alot.</P><P><A href="https://community.qlik.com/message/441803">Star Schema or Snow Flaxe schema?</A></P></BODY></HTML> Tue, 04 Feb 2014 05:25:51 GMT https://community.qlik.com/t5/QlikView/Star-Schema-or-Snow-flow-Schema/m-p/602275#M1118283 2014-02-04T05:25:51Z Re: Star Schema or Snow flow Schema https://community.qlik.com/t5/QlikView/Star-Schema-or-Snow-flow-Schema/m-p/602276#M1118284 <HTML><HEAD></HEAD><BODY><P>Thank you </P></BODY></HTML> Tue, 04 Feb 2014 05:29:12 GMT https://community.qlik.com/t5/QlikView/Star-Schema-or-Snow-flow-Schema/m-p/602276#M1118284 2014-02-04T05:29:12Z Re: Star Schema or Snow flow Schema https://community.qlik.com/t5/QlikView/Star-Schema-or-Snow-flow-Schema/m-p/602277#M1118285 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt;"><SPAN style="font-family: Arial, sans-serif;">Star Schema is better because of</SPAN></P><P></P><OL style="list-style-type: decimal;"><LI><SPAN style="font-family: 'Arial','sans-serif'; color: black;">Has redundant data and hence less easy to maintain/change</SPAN></LI><LI><SPAN style="font-family: 'Arial','sans-serif'; color: black;">Less complex queries and easy to understand</SPAN></LI><LI><STRONG style=": ; color: #000000; font-size: 15px; font-family: Georgia, serif; font-weight: normal;">Less no. of foreign keys and hence lesser query execution time</STRONG></LI><LI><STRONG style=": ; color: #000000; font-size: 15px; font-family: Georgia, serif; font-weight: normal;">Good for datamarts with simple relationships (1:1 or 1:many)</STRONG></LI><LI><STRONG style=": ; color: #000000; font-size: 15px; font-family: Georgia, serif; font-weight: normal;">Fewer Joins</STRONG></LI><LI><STRONG><SPAN style="color: #000000; font-size: 15px; font-family: Georgia, serif; font-weight: normal;">Contains only single dimension table for each dimensio</SPAN>n</STRONG></LI></OL></BODY></HTML> Tue, 04 Feb 2014 05:31:26 GMT https://community.qlik.com/t5/QlikView/Star-Schema-or-Snow-flow-Schema/m-p/602277#M1118285 2014-02-04T05:31:26Z Re: Star Schema or Snow flow Schema https://community.qlik.com/t5/QlikView/Star-Schema-or-Snow-flow-Schema/m-p/602278#M1118286 <HTML><HEAD></HEAD><BODY><P>Thank u </P></BODY></HTML> Tue, 04 Feb 2014 05:40:08 GMT https://community.qlik.com/t5/QlikView/Star-Schema-or-Snow-flow-Schema/m-p/602278#M1118286 2014-02-04T05:40:08Z