Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
What are the advantages and disadvantages of Link table and concatenation approach?
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.
why we should not use concatenate method when we have different granularity between fact tables
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
sorry what you mean by "Looks like the goal" ?
I meant that is your post about adv / disadv both methods is more than correct and complete. So I call it "the goal" 😃