Forum Discussion

alexanderg's avatar
alexanderg
Icon for Advocate II rankAdvocate II
10 years ago

Best Way for work with Multiple Fact Tables

Hi everybody!!   which is the best technique for working with models that have multiple fact tables and so get a star schema?. For example, in QlikView there is a technique called "linktable".   ...
Need Help
Show and Tell
Tips and Tricks
Chris12's avatar
Chris12
Icon for Advocate I rankAdvocate I
8 years ago

I'm new to this so take it with a grain of salt...

 

Seems to me that duplicating the Calendar table would solve your problem, indeed improve your model since the order dates and "adword dates" shouldn't be collapsed?!

vikrantarora25's avatar
vikrantarora25
Icon for Helper I rankHelper I
6 years ago

Chris12 that's not required, if you have 2 or more date columns in same table (like order date & ship date) then you need another date dim table. A single date dim table can be connected to 2 fact tables no prblem with that.