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
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?
If the Oracle sequencer is a must-have, then I would simply use three SQL transformations to invoke the sequence three times; then forward each of the sequence values to one particular EXP.