topic [TOS 2.4.2] tMap ordering Main out connections in Talend Studio

[TOS 2.4.2] tMap ordering Main out connections

Anonymous — Sat, 16 Nov 2024 14:13:46 GMT

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

amaumont — Thu, 11 Sep 2008 16:26:50 GMT

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

Re: [TOS 2.4.2] tMap ordering Main out connections

Anonymous — Fri, 12 Sep 2008 08:28:36 GMT

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