Forum Discussion
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". ...
This image ilustrate the Linktable
This diagram is strictly to overcome a modeling issue in qlikview and NOT associated with dimensional modelng at the database level, or even with many BI tools. PowerBI, Tableau and other tools do not have this modeling issue. That said, I love QlikView and can model that scenario without the link table. ALWAYS concatenate facts in qlikview.