topic Re: tell which schema it is ? in QlikView https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816409#M1037688 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i feel guilty because every one is working on qlikview , but there are many queries buy identifying the schema name it self.</P></BODY></HTML> Mon, 05 Jan 2015 14:59:47 GMT Anonymous 2015-01-05T14:59:47Z tell which schema it is ? https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816401#M1037678 <HTML><HEAD></HEAD><BODY><P>Hi , pls give name for each picture under which schema it follows</P></BODY></HTML> Mon, 05 Jan 2015 12:30:29 GMT https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816401#M1037678 Anonymous 2015-01-05T12:30:29Z Re: tell which schema it is ? https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816402#M1037679 <HTML><HEAD></HEAD><BODY><P>1. Snowflake</P><P>2. Star (messed up)</P><P>3. Star</P><P></P><P>That is, if each time the central table is your single Facts table.</P><P></P><P>Best,</P><P></P><P>Peter</P></BODY></HTML> Mon, 05 Jan 2015 12:33:02 GMT https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816402#M1037679 Peter_Cammaert 2015-01-05T12:33:02Z Re: tell which schema it is ? https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816403#M1037680 <HTML><HEAD></HEAD><BODY><P>star (messedup) means what </P></BODY></HTML> Mon, 05 Jan 2015 12:34:10 GMT https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816403#M1037680 Anonymous 2015-01-05T12:34:10Z Re: tell which schema it is ? https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816404#M1037681 <HTML><HEAD></HEAD><BODY><P>PNG1&nbsp; Star Schema</P><P>PNG3 Star Schema with data Island</P><P>PMG2 Star Schema with two fact tables .. Fact to Fact joins are not recommended to you can create two star schema for that. </P></BODY></HTML> Mon, 05 Jan 2015 12:40:48 GMT https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816404#M1037681 Anonymous 2015-01-05T12:40:48Z Re: tell which schema it is ? https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816405#M1037683 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I guess, judging by the pictture, Peter means that you have a "data_island" (that is, a table - the calendar - which is not linked to any other. That makes the performance of the app worse - plus you cannot use fields from that table, e.g. as dimensions. It works - sometimes data_islands just cannot be helped, I have some in my apps, too - but if possible it should be avoided.</P><P>HTH</P><P></P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Mon, 05 Jan 2015 12:42:12 GMT https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816405#M1037683 datanibbler 2015-01-05T12:42:12Z Re: tell which schema it is ? https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816406#M1037685 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>All there are Star Schema as <SPAN class="j-status-levels"><IMG alt="Expert" src="https://assets.bunchball.net/badges/levels/L5.png" title="Expert" /></SPAN><SPAN class="j-post-author"><STRONG><A _jive_internal="true" class="jiveTT-hover-user jive-username-link" data-avatarid="9356" data-externalid="" data-presence="null" data-userid="152230" data-username="balkumarchandel" href="https://community.qlik.com/people/balkumarchandel"><SPAN style="color: #3778c7;">balkumarchandel </SPAN></A></STRONG></SPAN>said second one is Star Schema with data Island</P></BODY></HTML> Mon, 05 Jan 2015 12:44:15 GMT https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816406#M1037685 2015-01-05T12:44:15Z Re: tell which schema it is ? https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816407#M1037686 <HTML><HEAD></HEAD><BODY><P>Dear CommonQlik,</P><P></P><P>Snowflake schema and star schema,</P><P></P><P><STRONG>dm2.png =&gt;</STRONG> Snowflake Schema</P><P><STRONG>Attachment dim3.png =&gt;</STRONG> Star Schema</P><P><STRONG>Attachment data model1.png =&gt;</STRONG> Star Schema</P><P></P><P>Listed below image will help you to understand the schemas.</P><P></P><P><IMG alt="Schema.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/74609_Schema.png" style="height: auto;" /></P><P></P><P></P><P>Kind regards,</P><P>Ishfaque Ahmed</P></BODY></HTML> Mon, 05 Jan 2015 12:51:10 GMT https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816407#M1037686 engishfaque 2015-01-05T12:51:10Z Re: tell which schema it is ? https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816408#M1037687 <HTML><HEAD></HEAD><BODY><P>Hi all are Star <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Schemas ............</SPAN></P></BODY></HTML> Mon, 05 Jan 2015 12:51:39 GMT https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816408#M1037687 2015-01-05T12:51:39Z Re: tell which schema it is ? https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816409#M1037688 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i feel guilty because every one is working on qlikview , but there are many queries buy identifying the schema name it self.</P></BODY></HTML> Mon, 05 Jan 2015 14:59:47 GMT https://community.qlik.com/t5/QlikView/tell-which-schema-it-is/m-p/816409#M1037688 Anonymous 2015-01-05T14:59:47Z