Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is link table how it works. and its usage.
please help me friends
Link table is used in a data model when you have multiple fact tables to handle. Another way to handle multiple fact table is concatenate, so you can find some post on link table vs concatenate,
Get started with developing qlik datamodels
for link tables you can try here
http://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/
Indeed, duplicate of another discussion by the same poster.
Hi Babu,
In Data warehousing - Star schema usually have a single Fact in the centre and dimensions surrounding it but sometimes you have a situation where you have more than one Fact table.
In Qlikview,You come across a situation where you have to handle multiple Fact tables, which in turn create synthetic keys or Circular references(Loops).
Link Table is a very useful way to resolve synthetic keys and Circular references(Loops) when multiple fact tables are present in the data model.
Link table is used, when the granularity of the facts tables are different and when they are joined to different dimensions.
To resolve these synthetic keys Link table:
Regards
Neetha