topic Synthetic key Issues in QlikView

Synthetic key Issues

Wed, 06 Jun 2012 05:51:01 GMT

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 — Wed, 06 Jun 2012 07:28:26 GMT

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;

Wed, 06 Jun 2012 09:30:53 GMT

Thanks for your response....

i will try with your solution

nilesh_gangurde — Wed, 06 Jun 2012 09:57:47 GMT

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.

You can concate the tables as Masha told.

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

Regards,

Nilesh Gangurde