topic Star & snowflake in QlikView https://community.qlik.com/t5/QlikView/Star-snowflake/m-p/892890#M1011723 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P>What is star schema &amp; snowflake schema ? what is the difference between star &amp;snowflake&nbsp; schemas with diagram ?</P></BODY></HTML> Thu, 23 Apr 2015 09:30:24 GMT qlikview979 2015-04-23T09:30:24Z Star & snowflake https://community.qlik.com/t5/QlikView/Star-snowflake/m-p/892890#M1011723 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P>What is star schema &amp; snowflake schema ? what is the difference between star &amp;snowflake&nbsp; schemas with diagram ?</P></BODY></HTML> Thu, 23 Apr 2015 09:30:24 GMT https://community.qlik.com/t5/QlikView/Star-snowflake/m-p/892890#M1011723 qlikview979 2015-04-23T09:30:24Z Re: Star & snowflake https://community.qlik.com/t5/QlikView/Star-snowflake/m-p/892891#M1011724 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>it has nothing to do with diagrams.</P><P>It's about data_modeling. Ideally, your table_associations should look like a star, with one fact_table and a number of dimension_tables around it (which just add more info on some of the fields in the fact_table).</P><P>Snowflake_schema is the next best when that cannot be done, e.g. when you have several fact_tables.</P><P>In practice, though, that is not so terribly important - when your app works and delivers the figures you need, you're all right.</P></BODY></HTML> Thu, 23 Apr 2015 09:33:59 GMT https://community.qlik.com/t5/QlikView/Star-snowflake/m-p/892891#M1011724 datanibbler 2015-04-23T09:33:59Z