topic What is a Link Table and when would you use it? in QlikView

What is a Link Table and when would you use it?

Tue, 07 Apr 2015 12:00:43 GMT

Hello

Can anyone please help me understand what is a Link Table and when might you use it?

I have read some web pages but still cannot get my head around it!

Is it like a middle man table than provides link to other tables?

Re: What is a Link Table and when would you use it?

Anonymous — Tue, 07 Apr 2015 12:07:36 GMT

Hi ,

Link table use to remove synthetic keys in qv,

go through this doc . MASTERTABLE (LINKTABLE or Concatenated FACT Table)

lots of discussion available in community as well go through Henric 's (HIC) blogs as well.

Thanks

BKC

Re: What is a Link Table and when would you use it?

buzzy996 — Tue, 07 Apr 2015 12:11:11 GMT

Is it like a middle man table than provides link to other tables? --yes ur right!

and we can also called as key table/link table solution,it helps to manage relations with most of the other table we can map accordingly needs.

Re: What is a Link Table and when would you use it?

Tue, 07 Apr 2015 12:26:52 GMT

Hi,

Link Table is used when we have multiple fact tables and more than one common fields in all tables. If you load all these tables, it will create synthetic keys as it has similar fields. Link table is also used when you have different dimensions in tables.

By using Link table, you can create a key field by joining all common columns in a field and then create a separate table as Link table and remove the common fields from original table. Now you can join all tables by using this Key field.

Hope it helps.