Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
udaya_kumar
Specialist
Specialist

Data Model - 4 fact tables - Synthetic keys

Hi,

I have 4 fact tables, 2 fact tables are having 5 id's in common and other 2 fact tables are having 2 id's in common.

After reload, it is forming a synthetic key table because of common id's between tables. There are millions of records and so many fields in each table.

So what is the best way to remove synthetic key?

Join (Join 2 fact tables with 5 common id's and join other 2 fact tables with 2 common id's , it will create final 2 fact tables, Is this fine?)

Concatenate (There are so many fields in the table, so if we concatenate the tables, then the table will have duplicate id's right?)

Linked table (If we have to create a linked table, do we need to create 2 linked tables to link 4 fact tables as 2 fact tables are having 5 id's common and other 2 fact tables have 2 id's in common)

How to solve this issue?

2 Replies
miguelbraga
Partner - Specialist III
Partner - Specialist III

Hey there,

Can you please share with us a screenshot of your Data Model, it is more clear to see what is your sync tables and what field(s) you should or shouldn't rename.

PS: I'll analyse and then provide you a solution.

Regards,

MB

miguelbraga
Partner - Specialist III
Partner - Specialist III

What you must do first is to read carefully the attached document. After that consider yourself to remodel the structure of the fact tables or even analyse the possibilty to concatenate all 4 fact tables into one and make a flag that identifys where the data comes from.

Ex:

     'Orders' as Flag_Fact,

Regards,

MB