Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community
Quick question about FACT tables. If I have a data model with tables that consist of different levels of granularity, can these tables all be combined into 1 fact table?
For example:-
Is it OK to combine table A and B into 1 fact table?
Thanks Community
Let me know if you need any more detail
Depends on how many rows of data are you expecting the FACT table to contain, are you going to do any count(Distinct ) calculations
Join your fact table one by one to see operational efficiency ...as long as you don't see any lag in your dashboard you should be fine...if you do then split your table again.