Forum Discussion

Enan's avatar
Enan
Icon for Helper I rankHelper I
3 years ago

star schema for multiple fact tables

 

Hi,

I have made a below model with 03 fact tables.

I cannot combine the facts as there are different columns in each fact table.

Please advise if this is the correct way of doing by following star schema.

Thank you.

 

Need Help
Show and Tell
Tutorial Requests

2 Replies

    • Enan's avatar
      Enan
      Icon for Helper I rankHelper I
      3 years ago

      Thank you Amit, i just wanted to check with experts that the modelling is correct.

      As per my understanding Star schema can have one fact table.

      But in this dataset there are 03 so i got confused as this does not fullfull the star schema criteria.