2 tDBInput in same job

[heshkaru]

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

[Anonymous]

Hello,

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