https://community.qlik.com/t5/QlikView/Data-Modeling-Question/m-p/1510034#M750282 1) I've never heard a special name for it.<BR />2) you will not have any performance issues with it.<BR />3) No need to avoid it. This design is better than a design where you duplicated this field to just to get single connections.<BR /><BR />Good work! Tue, 20 Nov 2018 21:04:44 GMT Vegar 2018-11-20T21:04:44Z https://community.qlik.com/t5/QlikView/Data-Modeling-Question/m-p/1510027#M750281 <P>Hi</P><P>I have a model with three tables linked, but without syntetic keys. I don't know the name of this "kind" of link, cause i know it is not a syntetic or link table... Also, I wonder if this causes performance issues or not.</P><P>1) What is the name of this kind of link</P><P>2) Does this causes any performance issues?</P><P>3) Should I avoid it if possible or how should I model this?</P><P>Thanks!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Three Table Union.png" style="width: 608px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/683i2CFE9B89CC079AC6/image-size/large?v=v2&amp;px=999" role="button" title="Three Table Union.png" alt="Three Table Union.png" /></span></P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Data-Modeling-Question/m-p/1510027#M750281 cristian_av 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Data-Modeling-Question/m-p/1510034#M750282 1) I've never heard a special name for it.<BR />2) you will not have any performance issues with it.<BR />3) No need to avoid it. This design is better than a design where you duplicated this field to just to get single connections.<BR /><BR />Good work! Tue, 20 Nov 2018 21:04:44 GMT https://community.qlik.com/t5/QlikView/Data-Modeling-Question/m-p/1510034#M750282 Vegar 2018-11-20T21:04:44Z