Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Why and When do we use Link tables in QV data modeling . How is it different from Concatenation or joining the tables .
Thank you !
You use a Link table when the facts do not share all the same dimensions.
This blog :Concatenate vs Link Table should be helpful.
if there are more than one fact table we create link table
A table which links between two tables having relationship One to Many.
That would mean you have a link table between almost every table.
I think you are mistaking "link table" for "link".
Hi,
Please go through following links,
what is use of link tables ,how to use it
What is Link Tables? What is the use?
thanks,
bunny
Hi Mamtha,
In Data warehousing - Star schema usually have a single Fact in the centre and dimensions surrounding it but sometimes you have a situation where you have more than one Fact table.
In Qlikview,You come across a situation where you have to handle multiple Fact tables, which in turn create synthetic keys.
Link Table is a very useful way to resolve synthetic keys when multiple fact tables are present in the data model.
Link table is used, when the granularity of the facts tables are different and when they are joined to different dimensions.
To resolve these synthetic keys Link table:
Thank you Neetha !