Two fact tables - one big dimension table

[#1]

Hi All,

I have following scenario:

I have 2 quite big fact tables with three fields that I want to filter (each one separately).

My first idea is to create one dimension table. The problem is that when join 3 tables with 120 records each, as a result I would get table with 15625000 records. My application slows down immediately.

Maybe you have different way of handling this kind of situation?

Looking forward to hear from you all.

Kind regards,

Janusz

[#2 · Accepted solution]

Hi

I would build a link table that sits in the middle of all the tables,

There are various discussions on the community relatig to link tables, here is one of them:

http://community.qlik.com/forums/t/16164.aspx

Search for Link Table on the community to get more.