Hi;
what are the advantages of link table?
is it fr removing synthetic key?
or another purpose?
Thanking you
venu
Hi Venu,
The main purpose of Link table is for removing the Synthetic key and Circular references. By using Link tables effective data models are created.
Regards,
Jagan.
Hi
See this example
http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/17/concatenate-vs-link-table
Is one of the most comon way to eliminate Circular reference, cut all the relation between tables and create a only table linked by all the others table
good luck
Fernando
Hii.
In the event of multiple fact tables QlikView In-Memory Technology allows us to create a central link table that only contains the existing data combinations. Instead of Joining the tables the event dimensions can be merged (CONCATENATED) in to one central Link table. This link table can then be linked back to the event measures one side and
the dimension tables on the other.
Please find sample for the same,
Vikas
hi
By the use of Link table we remove the synthetic key and circular reference,
we can also remove synthetic key and circular reference by using join, concatenate, change alias.
but by link table no need of join, concatenate, change alias.
simply you create another table which is linked with table that is called Link table.
Hi Venu
Find the document i hope it helpful to you.
regards
Boby
When you have multiple Fact tables in QlikView, it can be handled in 2 ways, by using concatenate or by using Link tables. If the granularity and columns in the fact tables are same then you can useConcatenate which will merge the tables into one and resulting table will have the sum of rows of the twotables.
It would be excellent if you can also upload the dummy document of when to use Link Table example for the pharmaceutical industry mentioned in the doc.
In case of Link table, what schema it would create ?