5 Replies Latest reply: Apr 30, 2018 3:39 PM by vidya sagar malla RSS

    Dont create Synthetic Key between two tables

    vidya sagar malla

      Hi,

       

      I two requirements from one QVD called TEST.QVD.

       

      1. [TEST_ONE]:

      LOAD

      firstname,

      lastname,

      mobilenumber,

      company,

      managername

      from [TEST.QVD]

      where managername <> null and company<> 1234

      I am getting 50 records from this table

       

      2. [TEST_TWO]:

      LOAD

      firstname,

      lastname,

      mobilenumber,

      company,

      managername

      from [TEST.QVD]

      I am getting 100 records from this table.

       

      This two data tables load into single APP. One for sheet1 another for Sheet2. But the Problem is by default synthetic key is creating between these two table and because of that second table loading with only 50 records. Please guide me with the better approach.

       

      Thanks,

      -Vidya