Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Link table instead of Joining

Hello All,

We use link table instead of joining fact tables, is there any performance issue because of this?

Thanks.

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

Joining fact tables is dangerous. You may duplicate records this way, and then numbers will be double counted.

Concatenating fact tables is however safe - and usually has better performance than a link table.

HIC

View solution in original post

3 Replies
MK_QSL
MVP
MVP

Depends on your data model. Link Table is generally used to avoid synthetic key/table.

hic
Former Employee
Former Employee

Joining fact tables is dangerous. You may duplicate records this way, and then numbers will be double counted.

Concatenating fact tables is however safe - and usually has better performance than a link table.

HIC

Not applicable
Author

Hi,

You can deal with multiple fact tables effectively with help of link table ....There will be some slow processing based on the data you have in fact tables.

But dont join fact tables in any case because you will lose control over your result set

Try to solve this case only with concatination of fact tables