Multiple fact tables

Wed, 14 Aug 2013 11:50:17 GMT

Hi everyone,

Is there somebody that could explain the difference between a data model with 2 fact tables linked by a link table and a data model with also 2 fact tables but linked by a dimension?

How exactly do you implement them?

What are the advantages and disadvantages of each solutions.

Thanks

Caro.

Re: Multiple fact tables

orital81 — Wed, 14 Aug 2013 13:50:17 GMT

Hi Caroline

Basically, there are 2 approaches:

1. Concatenate both facts into 1 fact table and connect all dimentions to it.

This is also called Star Schema and it's the most common and simple to apply.

2. Key Table - all facts and dimentions are linked to 1 Key table.

The pros and cons are explained very well in QlikView free training service (http://www.qlik.com/us/services/training) The training is called: Technical Pathway - Qlikview 10 Modeling Best Practices (7/8/2011)

Also, you may find a good PDF that explains it.

See attachment

All the best,

Ori

topic Re: Multiple fact tables in QlikView

Multiple fact tables

Re: Multiple fact tables