Hi Is it possible to manage the order and consistency of multiples "out" links ?
J've to do two consistent inserts after my tMap component like this:
tMap --> out1 (Main: order 1) -->tOracleOutput1 (parent table) | --> out2 (Main: order 2) -->tOracleOutput2 (child table) *** Modifying the order in Designer has no effect on the java generated code. *** J can't use the trigger link from tOracleOutput1 to tOracleOutput2, how can be managed an unique commit for two tOracleOutput ? Any idea ? Best regards msomso
Re: [TOS 2.4.2] tMap ordering Main out connections
Hi, J've seen that the rejects are managed after the "non-reject" outputs. But, in my job J'd like to order two "non-reject" outputs. Is-it possible, how do you manage the consistency ? J'd like to force the insert1 (output1 - NON REJECT) before insert2 (output2 - NON REJECT), then: If error on insert 1 J've to - switch to next row of my input (without insert2) If error on insert 2 J've to - rollback insert1 and - switch to next row of my input. Is-it possible without stopping the job ?