topic Synthetic key issues in QlikView

Synthetic key issues

Wed, 06 Jun 2012 05:52:53 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

Synthetic key issues

christophebrault — Wed, 06 Jun 2012 09:14:10 GMT

Hi,

You should try to concatenate your table to have only one fact table. To concatenate, you must have the same fields in your table. Add null() as FieldName to match tables each other.

Re: Synthetic key issues

Wed, 06 Jun 2012 11:15:53 GMT

1 - Synthetic keys do not create new record in tables.

2 - try creating a common key concatenating your 4 column:

column1 &'|'& column2 &'|'& column3 &'|'& column4 as Key_FactTable

then comment or qualify the 4 fields in the 3 fact tables.

Marco B.

Synthetic key issues

Thu, 07 Jun 2012 10:38:57 GMT

Hi Macro,

How this common key will help full to retrieve data from all the 4 fact tables

suppose i will select only 2 columns from two dimension tables it will reflect all the 4 fact tables or not,these 2 columns are in 4 fact tables

Synthetic key issues

Thu, 07 Jun 2012 11:41:54 GMT

Hi,

You need to concatenate the 3 Facts table with the 4 column name putted as same and while concatenating the Facts table you need to create a composit key in each fact Table(or use the primary code) which will be linked to the Facts tables resptively. This will create a star schema with link table(the concatenated one).