Should we create different fact tables for different business values?
As shown in the one of the examples like for ride platform we can have one fact table for trip etc…
Now for users operation we have one fact table, for marketing expense and other expense we will have different fact table.
This fact table can have same or different dimensions.
This is correct understanding?
Hello @hardikg,
I think it all comes down to the difference between using a highly normalized form or create a data mart structure inside the data warehouse (Inmon or Kimball approach).
In your case if you want data quality as priority just use different fact tables for different business values, such as 3NF would be a better choice and choose the same or different dimensions inside.
Instead use multiple dimensional star schemas if you want faster iteration and modeling with the trade-off of potential looser data integration, data redundancy and duplication (Chapter 8 of the book)