[TOS 2.4.2] tMap ordering Main out connections

One Star

[TOS 2.4.2] tMap ordering Main out connections

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
Employee

Re: [TOS 2.4.2] tMap ordering Main out connections

Order your output tables into tMap.
In fact the job designer does not show the real order of tMap outputs, it's the 1428.
One Star

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 ?

Best regards
msosmo