Synthetic key Issues

[#1]

Hi can any one help me in synthetic key issues...

1.  Synthetic keys create any duplicate records in tables at the time of Data Retrival........

2.  I have 3 fact tables and 4 columns are common in these 3 fact tables.

     these 3 facts are required in my data model.

    how i will i eliminate synthetic keys here

3.Synthetic keys cause any performance issues in data model

[masha-ecraft]

You can concatenate your fact tables into one table and there will be no synthetic keys, just 4 common fields.

Or you can create your own unique key to link the tables:

LOAD
...
key1 as table1_key1,
key2 as table1_key2,
key3 as table1_key3,
key4 as table2_key4,
key1 & '/' & key2 & '/' & key3 & '/' & key4 as key;

[#3]

Thanks for your response....

i will try with your solution

[nilesh_gangurde]

Hi Guru,

To avoid the synthetic keys you can rename the fields by which you dont want to link the fact table.

renaming the field avoids the synthetic kyes.

OR

You can concate the tables as Masha told.

OR

You can create the link table to connect the fact tables with the more than one field.

Regards,

Nilesh Gangurde