Advantages of Link Table;

[#1]

Hi;

what are the advantages of link table?

is it fr removing synthetic key?

or another purpose?

Thanking you

venu

[jagan]

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.

[fkeuroglian]

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

[vikasmahajan]

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

[#5]

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.

[#6 · Accepted solution]

Hi Venu

Find the document i hope it helpful to you.

regards

Boby

[Anonymous]

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.

[adamgaox]

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.

[Shubham_D]

In case of Link table, what schema it would create ?