What is the use of link table?

[#1]

Hi to all the experts in qlik view,

I wan to clearly understand the concept of link table,can anyone help me out.

Thanks

Harshitha

[Kushal_Chawda]

Link table is called as 'Factless Fact' in data warehouse term in which you have only dimensional keys.

When you have two Fact tables with many to many relationship we create a link table to connect two Fact tables.

For example see the below link

https://community.qlik.com/thread/132848

[qlikmsg4u]

One more

Advantages of Link Table;

[#4]

Thank you Kush i understood the importance of link table.

Regards

[qv_testing]

Hi,

* When there are common fields in multiple tables (a synthetic key exists) but most of the fields

from each table are not shared.

* It is a table that stores all possible combinations of values.

* When there is more than one field in common between tables.

* Use: To maintain integrity of your application.