data modeling with 2 Fact Tables

madhubabu — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

If I have 2 fact tables with only one common field between those 2 tables in a data model what will happen if I don't use Link table/concatenation/Join.

Only If I have association with those 2 fact tables.How does it impacts our data model?

Thanks,

Madhu

Re: data modeling with 2 Fact Tables

Anonymous — Mon, 24 Apr 2017 09:19:54 GMT

Then you'll have to decide to which fact table wou'll have to link your master data (Region, product, calendar etc.).

Depending on the Facts, it may happen, that you'll lose some information if the two fact table are not always linked properly.

For instance: if you have 2 fact tables: sales and offers, which are linked via one key.

Then you'll want to link the product table to your data modell. If you chose to link the product table to the sales table: It may happen that there is no sales data for one product but offers. The offers will not anymore be related to the product, since the sales data related to that product is missing.

You can easily give it a try with a small sample data set to witness it on your own.

topic data modeling with 2 Fact Tables in QlikView

data modeling with 2 Fact Tables

Re: data modeling with 2 Fact Tables