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 data model 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 appropriate result.
Concatenation works well enough when we have all the fields same.
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.
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 data model 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 appropriate result.
Concatenation works well enough when we have all the fields same.
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.
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
