Joining Multiple Fact Tables in Data Marts

[TMcC]

Is it possible to join and\or left join multiple fact tables from the data warehouse when creating a data mart.  For example: Two fact tables have the same ID's and the same Date.  Joining or left joining those fact tables will create a single fact table with all the facts for the same ID and Date.

I can work around this using a post loading process.  Are there other options?

[abhijitnalekar · Accepted solution]

Hi @TMcC ,

Yes, we can join the two fact tables and convert them into one fact table.

Qlik also suggests creating star schema on the model level to retrieve the data quickly and using the above method we can do the same. 

I have also applied the same method in my environment and it works perfectly for me.

[Dana_Baldwin]

Hi @TMcC , did @abhijitnalekar comment help? If so, please click the "Accept as Solution" button.

Thank you!