Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
vsharma1
Partner - Creator
Partner - Creator

Link Table & Concatenation

Hello ,

What are the advantages and disadvantages of Link table and concatenation approach?

7 Replies
Sergey_Shuklin
Specialist
Specialist

Hello!

Here you may find a comparison:
https://www.learnallbi.com/link-table-in-qlikview/
In short words: link table is less memory consuming decision.

vsharma1
Partner - Creator
Partner - Creator
Author

why we should not use concatenate method when we have different granularity between fact tables

Sergey_Shuklin
Specialist
Specialist

Hello!

You may use concatenate for different granularity - it's ok. For instance if you have two same tables - one for months and one for weeks, so you can easily union them. No need to use link table. But, if your tables match only with few fields (customer + country) so the better way is to use a link table with a key.
vsharma1
Partner - Creator
Partner - Creator
Author

Hello,

 


Please add if i miss anything on below

 

Link table

 

Advantages:

Should be useful when we have less number of common dimensions available to form a Key between Fact tables

 

Disadvantage:

Link table may cause performance issue in future due to increase in its size

 

 

Concatenation:

 

Advantages:


Suitable when we have large number of common dimensions between fact tables

 


Disadvantages:

Consume more memory

 

 

Sergey_Shuklin
Specialist
Specialist

Looks like the goal.
One more advantage of concatenation:
You can use it instead of JOINs for avoiding record multiplying (if you get such cases during tables join).
vsharma1
Partner - Creator
Partner - Creator
Author

sorry what you mean by "Looks like the goal" ?

Sergey_Shuklin
Specialist
Specialist

I meant that is your post about adv / disadv both methods is more than correct and complete. So I call it "the goal" 😃