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?

       

      Thanks,