Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I don't know if I get this right about LINK_TABLE:
If we have many fact tables with columns: CUSTOMER and DATE, we can simply link them together with these two columns, which creates synthetic keys. The result will be the same as using LINK_TABLE. But since we want to avoid synthetics keys, we choose to use LINK_TABLE.
Am I right on this? Is the any tutorial regarding LINK_TABLE?
Thanks in advance!
Can we get a small demo that shows what you are trying to accomplish?
Sorry I don't have any demos. I just know there is LINK_TABLE, but don't understand what it is for and how to use it.
Yes,
You could say that is more or less what you are doing. The auto creates unique combinations just as a link table would.
See more here:
Hi Wanyun,
Link Tables are used to link data that would otherwise not be able to be linked within QlikView/QlikSense. It is also
one of the few tables in which you makes sense to have data at different granularity levels. Most probably developers use link table to avoid the synthetic key issue.
Now Let see with the example.
Hope this will helps you.
Check this, to give an idea: