3 Replies Latest reply: Aug 5, 2015 2:39 AM by Zain Shiekh RSS

    need suggetion regarding data model

      hi all,


                In My Datamodel i have two tables one table contains the sales represent details the second table contains sales represent performance details  the thing is 4 fields common between both tables when i load the data and then run synthetic table was formed

      to remove that synthetic table which approach is best

      1.join two tables or


      2.by using qualify for three fields except key field or


      3.remove common fields from one table  except key field


      here data is same for 4 fields in two tables