Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Tanish
Partner - Creator
Partner - Creator

Link table

Hi,

Can anybody explain, why we create link table rather than directly linking it with Composite keys.

Labels (1)
2 Replies
salonicdk28
Creator II
Creator II

Hi.

  • link table must be used when possible, as it keeps your data model more understandable and creates less 'hassle' on the front-end
  • With the use of link tables, it’s possible to keep the fact tables separated from each other. The advantage of this solution   for choosing this method is to keep the data model a logical one.
  • To remove synthetic keys and circular reference as well

Please refer below link and close the thread

https://community.qlik.com/t5/Qlik-Design-Blog/Concatenate-vs-Link-Table/ba-p/1467569

 

MendyS
Partner - Creator III
Partner - Creator III

@Tanish 

couple reasons,
the main to avoid syntactic and circles,
you can read about that - how to create ERD.