Data Model - 4 fact tables - Synthetic keys

[udaya_kumar]

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?

[miguelbraga]

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]

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