Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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

Re: Link table instead of Joining

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
MVP
MVP

Re: Link table instead of Joining

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

Re: Link table instead of Joining

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

Not applicable

Re: Link table instead of Joining

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