Discussion Board for collaboration related to QlikView App Development.
But What is Link Table? What is the use/advantage of Link Table?
Is it only to remove the Synthetic key or more.
Can pls explain in details
Thanks in Advance
Link tables are generally used for linking the two table or the fact tables.
Let us go with an example..
As we know that when we are designing the datamodel synthetic keys and circular loop are common.
For fixing this problems we use the link table concept.
You can also use concatenation ,but it always not give the appropiate result.
Concatenation works well enough when we have all the fields same.
With the use of link tables, it’s possible to keep the facttables separated from each other. The advantage of this solution for choosing this method is to keep the datamodel a logical one.
Please refer the following link. But its better to avoid link table.
Hope it helps u.
in qlikview if two table has a single common field, then these table automaticaly linked. called link table,
because qlikview work on associtive query languages(AQL).
now if between two tables more than one common field (suppose two common field)then it link two times via synthetik key.
There are two main strategies to modelling data in QlikView to handle multiple fact tables:
How to construct Link Tables is a complex subject but relies upon traditional database linking table design techniques. It is easy to go wrong and produce linking tables that may seem to produce the correct results in the front-end but is excessively large, consuming memory and CPU resources.
In my experience, a poorly modelled QlikView data model is the most common culprit for causing poor performance.
I hope this quick, far from exhaustive, introduction to multi-fact modelling in QlikView proves of some help and sets you on the right course.