Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
what is the link table? when we go for link table? explain with example?
Please check below
Hi,
Links tables are used In Qlikview,When 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:
HTH,
Hirish