5 Replies Latest reply: Feb 20, 2014 9:11 AM by Fabrice Aunez RSS

    Creating Candidate key

      Hey Guise

      I have two different tables which use two different month Id for the same month now I wants to merge them but it is displaying only one's record and generate synthetic key now I wants to create a composite key for both fields and I have used syntax but  it got failed. So is there any body who helps me to create composite key or any other solution for this, that make the both table's record visible and identify the both fields  in my fact table with single field.

       

      Regards

      Surbhi Sahu

      Bisp Solutions Inc

      www.bisptrainings.com