Data Warehousing Community Forum
November 21, 2018, 02:16:32 am

Pages: [1]   Go Down
  Print  
Author Topic: Two Facts or one Fact  (Read 656 times)
nasilyaa75
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 1


View Profile
« on: March 09, 2018, 06:06:07 pm »

Hey guys
I am very new to DW things, so I am very confused what the differences are between 1 fact or 2 facts. I have 1 fact table (ReviewRating) and probably another fact (ReviewSentimentScore). But is it not better to combine these and make 1 fact in terms of performance?

Thanks
Logged
advertisement
SuGoSu
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 5


View Profile
« Reply #1 on: November 05, 2018, 05:14:00 pm »

Hello,

My first post here ~

This can be answered correctly after checking out data and business process. But If its Kimball's dimensional modeling, with high chance, your case seems suitable for one fact.

If both measures atomic level (grain) are same on your data, for instance, Login User and Login Time are your primary key indicator, then you should combine them.
Something like Reviews_Fact can be the table's name.

I recommend you to check out Kimball's Data Warehouse Toolkit book.

Good luck.
Logged
Pages: [1]   Go Up
  Print  
Jump to: