topic Re: Trigger: Run If + On Subjob OK in Talend Studio

Trigger: Run If + On Subjob OK

PaulyWally — Tue, 26 Jan 2021 19:43:50 GMT

I would like to trigger a subjob with two inclusive conditions:

On Subjob OK
((Integer)globalMap.get("tDBInput_1_NB_LINE")) > 0

The main subjob extracts source data using

tDBInput_1, and flows into 1 of 2 outputs - an UPSERT or a DELETE.

I have a 2nd subjob that increments the change version. But I only want to increment the change version if tDBInput_1 has more than 0 rows, and also if the UPSERT and DELETE outputs do not fail.

Please see attached image.

Any ideas? TIA!

Re: Trigger: Run If + On Subjob OK

tnewbie — Tue, 26 Jan 2021 22:58:57 GMT

From the little I understood, you may take the 'on subjob ok' to a step prior / backwards. As I don't see your entire flow, this is just my 2 cents

Re: Trigger: Run If + On Subjob OK

PaulyWally — Wed, 27 Jan 2021 03:58:58 GMT

The rest of the flow is irrelevant. What I need is for the "Increment Change Version" to execute only if both conditions are true within the subjob that is shown in the pic:

CT_dbo_Task row count is greater than 0
The subjob shown in the pic completes without error

Using 'On Subjob OK' will trigger the "Increment Change Version" even if there are no rows. And using an 'Run If' will trigger the "Increment Change Version" even if tMap, Upsert, or Delete fail on an error.

Re: Trigger: Run If + On Subjob OK

Prakhar1 — Wed, 27 Jan 2021 06:02:36 GMT

a tJavaFlex may help.

CT_dbo_Task -->OnSubJobOk --> tJavaFlex --> RunIf (your Condition ) --> Increment Change Version

Re: Trigger: Run If + On Subjob OK

hanghan — Wed, 27 Jan 2021 10:11:33 GMT

Re: Trigger: Run If + On Subjob OK

JohnRMK — Sun, 31 Jan 2021 21:02:34 GMT

Best Practice also 🙂