Discussion Board for collaboration related to QlikView App Development.
We use link table instead of joining fact tables, is there any performance issue because of this?
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.
View solution in original post
Depends on your data model. Link Table is generally used to avoid synthetic key/table.
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