8 Replies Latest reply: Sep 29, 2017 3:23 AM by Ramzi Manoubi RSS

    Concatenate a joined table, without synthetic keys

    Ramzi Manoubi

      Hi,

       

      I have a table T1 with 6 records to which I want to add 4 extra records, which are the result of a cross join.

      When I run the load script, synthetic keys are created.

       

      Someone who can help me to get the desired result without synthetic keys?

      Also I'm having a hard time to understanding the behaviour of the execution of the load-script. If you can advice me articles to read, that would also be cool.

       

      Any help is greatly appreciated.

       

      //These values are loaded first

      T1:

      Load * Inline [

          COL1, COL2, COL3, COL4

          'A','1'

          'A','2'

          'A','3'

          'A','4'

          'A','5'

          'A','6'

      ];

       

      //There extra rows are added afterwards

      Load * Inline [

          COL1

          'A'

      ];

      join

      Load * Inline [

          COL2

          '7'

          '8'

          '9'

          '10'

      ];

      join

      load * inline [

          COL3, COL4

      ];

       

      Thank you,

      Ramzi