3 Replies Latest reply: Jun 6, 2012 5:57 AM by Nilesh Gangurde RSS

    Synthetic key Issues

      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