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

Link table


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

Labels (1)
2 Replies
Creator II
Creator II


  • 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


Partner - Creator III
Partner - Creator III


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