Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello got multiple fact tables
I want to create a linktable / bridge table to link them together and thus create a schema
what are the rules in this case?
how do I choose the keys from each fact table and how to link them in the link table?
kindly advise
Your link table has all common fields between your fact tables (example dimension foreign keys). Fact tables only contain the unique fields. The rest of your data model associates to the link table.
If your fact tables are similar in structure, you can choose to concatenate (union) fact tables instead of a link table.
So you mean fact tables link to the bridge table via the unique keys of each row or not necessarily?
Yes. You'll need to add appropriate keys to the link table to associate to each fact, or create composite keys for each table with appropriate fields in qlik. It's essentially a synthetic table that qlik auto generates in this scenario.
Take a look at this post:
https://community.qlik.com/t5/Qlik-Design-Blog/Fact-Table-with-Mixed-Granularity/ba-p/1468238