Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
We use link table instead of joining fact tables, is there any performance issue because of this?
Thanks.
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
Depends on your data model. Link Table is generally used to avoid synthetic key/table.
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
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