Forum Discussion

CapucineBenier's avatar
CapucineBenier
Frequent Visitor
3 years ago

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

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 🙂