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

[#1]

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?

[Anonymous]

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

[buzzy996]

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.

[#4]

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.