topic Re: Advantages of Link Table; in QlikView

Advantages of Link Table;

Fri, 14 Mar 2014 00:59:06 GMT

Hi;

what are the advantages of link table?

is it fr removing synthetic key?

or another purpose?

Thanking you

venu

Re: Advantages of Link Table;

jagan — Fri, 14 Mar 2014 01:58:02 GMT

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.

Re: Advantages of Link Table;

fkeuroglian — Fri, 14 Mar 2014 03:18:08 GMT

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

Re: Advantages of Link Table;

vikasmahajan — Fri, 14 Mar 2014 03:47:53 GMT

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

Re: Advantages of Link Table;

Fri, 14 Mar 2014 04:13:58 GMT

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.

Re: Advantages of Link Table;

Sun, 16 Mar 2014 04:05:08 GMT

Hi Venu

Find the document i hope it helpful to you.

regards

Boby

Re: Advantages of Link Table;

Anonymous — Sat, 17 Mar 2018 14:17:13 GMT

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.

Re: Advantages of Link Table;

adamgaox — Wed, 30 Jan 2019 01:00:02 GMT

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.

Re: Advantages of Link Table;

Shubham_D — Thu, 22 Apr 2021 15:20:31 GMT

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