Forum Discussion

alexanderg's avatar
alexanderg
Advocate 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
alexanderg's avatar
alexanderg
Advocate II
10 years ago

 This image ilustrate the Linktable

 

  • ddumas's avatar
    ddumas
    Frequent Visitor
    8 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi james_m - I have similar requirement, can you please tell me the process how to create the link table with multiple columns from more than 1 tables