6 Replies Latest reply: Jan 28, 2013 2:51 PM by Dicky Mohanty RSS

    issue with multiple 'concatenate's  (for incremental loading)

      Hi guys,

       

      I have two tables and two qvds (say table1, table2 and qvd1,qvd2)

      I am trying to concatenate the tables with respective qvds

      ex:

      table1

      concatenate

      qvd1

       

      and

       

      table2

      concatenate

      qvd2

       

      But my problem is only first concatenate is working. The second concatenate, instead of concatenating (or appending), it is replacing the qvd2 with the table2 data. I thought there could be something wrong with the second concatenate statement. But when I swapped the statements like

      table2

      concatenate

      qvd2

       

       

      and

       

       

      table1

      concatenate

      qvd1.

      Now the table2 and qvd2 concatenate is working fine but not the other one.

       

      So I want to ask if anybody has tried using multiple concatenate statements and has anybody faced this kind of issue. Does anyone have a solution?

       

      Thanks in advance