1 Reply Latest reply on Jun 18, 2021 5:47 AM by Nico Heinze

    Informatica SQL Transformation multiple queries

    Meet Patel New Member

      Hi everyone,


      I have a requirement to use oracle sequence next val to generate sequence at database.


      I have a mapping which is loading 3 separate tables using expression. However all 3 target tables have ID field and need to be populated using different sequence.


      When it's one sequence its not a problem.


      The flow is like this:

      SQ > SQL-T > EXP> TGT1                               > TGT2

                                     > TGT3


      I am created output port for TGT1_ID and placing a query: "select example_psq.nextval from dual;"


      When I create TGT2_ID port, I cannot change the query. it stays the same across all output ports.


      Can someone please assist?