2 tDBInput in same job

heshkaru — Fri, 25 Nov 2022 13:17:26 GMT

Is it possible to get below kind of a scenario.

tDBInput -> Select some value rows -> tDBInput using extracted values

But I have managed this in below way

tDBInput -> tFlowToIterate -> tFixedFlowInput -> tSetGlobalVar -> ChildJob(Contains the second tDBInput)

Since there are over 200 columns i need to specify 200 global variables and this is a batch job that runs every single minute. So the data load is huge(not sure this way will consume more resources)

Thank you

Re: 2 tDBInput in same job

Anonymous — Fri, 25 Nov 2022 14:29:13 GMT

Hello,

Have you considered doing a context.filter parameter and putting together a WHERE condition?

topic Re: 2 tDBInput in same job in Talend Studio

2 tDBInput in same job

Re: 2 tDBInput in same job