topic Re: Link table instead of Joining in QlikView https://community.qlik.com/t5/QlikView/Link-table-instead-of-Joining/m-p/935662#M323029 <HTML><HEAD></HEAD><BODY><P>Depends on your data model. Link Table is generally used to avoid synthetic key/table.</P></BODY></HTML> Thu, 08 Oct 2015 09:37:56 GMT MK_QSL 2015-10-08T09:37:56Z Link table instead of Joining https://community.qlik.com/t5/QlikView/Link-table-instead-of-Joining/m-p/935661#M323028 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>We use link table instead of joining fact tables, is there any performance issue because of this?</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 08 Oct 2015 09:35:57 GMT https://community.qlik.com/t5/QlikView/Link-table-instead-of-Joining/m-p/935661#M323028 2015-10-08T09:35:57Z Re: Link table instead of Joining https://community.qlik.com/t5/QlikView/Link-table-instead-of-Joining/m-p/935662#M323029 <HTML><HEAD></HEAD><BODY><P>Depends on your data model. Link Table is generally used to avoid synthetic key/table.</P></BODY></HTML> Thu, 08 Oct 2015 09:37:56 GMT https://community.qlik.com/t5/QlikView/Link-table-instead-of-Joining/m-p/935662#M323029 MK_QSL 2015-10-08T09:37:56Z Re: Link table instead of Joining https://community.qlik.com/t5/QlikView/Link-table-instead-of-Joining/m-p/935663#M323030 <HTML><HEAD></HEAD><BODY><P>Joining fact tables is dangerous. You may duplicate records this way, and then numbers will be double counted.</P><P></P><P>Concatenating fact tables is however safe - and usually has better performance than a link table.</P><P></P><P>HIC</P></BODY></HTML> Thu, 08 Oct 2015 09:46:00 GMT https://community.qlik.com/t5/QlikView/Link-table-instead-of-Joining/m-p/935663#M323030 hic 2015-10-08T09:46:00Z Re: Link table instead of Joining https://community.qlik.com/t5/QlikView/Link-table-instead-of-Joining/m-p/935664#M323031 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>You can deal with multiple fact tables effectively with help of link table ....There will be some slow processing based on the data you have in fact tables.</P><P></P><P></P><P>But dont join fact tables in any case because you will lose control over your result set</P><P></P><P></P><P>Try to solve this case only with concatination of fact tables</P></BODY></HTML> Thu, 08 Oct 2015 10:00:40 GMT https://community.qlik.com/t5/QlikView/Link-table-instead-of-Joining/m-p/935664#M323031 2015-10-08T10:00:40Z