Data Model - Better connect Fact table together or via Dim table ?

[CapucineBenier]

Hi,

I have several fact and dim tables and there is a link existing in between my fact tables.

Is it better to connect the fact table through their link and 1 fact table to the dim tables ?
Or is it better to connect all Fact table to all dim tables ?

See the old school model below 🙂 

  

[CapucineBenier]

Consolidated fact table is definitely not recommended as explained in the videos below from Guy In a Cube.

https://www.youtube.com/watch?v=TnyRsO4NJPc  

[Idrissshatila]

Hello @CapucineBenier ,

If the fact tables have the same columns and can be one table, it's better to combine all the fact tables in one table and then connect this table to the dimensions, else if this is not posssible then connect every fact table to all the dimensions.

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin