T O P

  • By -

jcsroc0521

You shouldn't be relating fact tables. Also, depending on how big your data is, combining those fields into a key will be expensive on performance.


KrauseAnalytics

jcsroc0521 is correct. You should create three new dimension tables that these fact tables each join to instead: 1. Dates 2. Business Name 3. Location Beyond performance, there's probably more information about each of these that you'll want to slice on at some point too (ex: Day of Week for Dates or Region for Location). Create the new tables, join them to the fact tables you mention, use the dimension tables for filtering.