1 Reply Latest reply: Mar 27, 2015 12:28 PM by Peter Cammaert RSS

    how to create fact table using dimension tables

      i have created QVD files ( Dimensions Tables )

       

      as i try to use to create fact tables so itself it creates synthetic key instead of mine

       

      what i want to do is

      1)   dimension table User

      userid key

      name

      address

       

      2) dimension  Table Target

      targetid key

      targetname

      area

      email

       

      3) fact table

      userid

      targetid


      how to achieve this