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

[christophebrault]

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.

[#3]

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.

[#4]

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

[#5]

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).