topic Re: How to iterate on multiple components after 1 component in Talend Studio

How to iterate on multiple components after 1 component

Anonymous — Fri, 01 Nov 2019 11:34:53 GMT

i have HDR table which has Id
based on this Id i need to query 1 child table passing this as input .After getting child table o/p i need to pass it iteratively at multiple places how to that in talend .

my flow :

(hdr) (child)

toracleinput->main->toracleinput-->iterate> ??? how to use iterate multiple times from child tables o/p..since it allows only 1 iterate link ?

Re: How to iterate on multiple components after 1 component

Aravind_Ravi — Fri, 01 Nov 2019 12:27:43 GMT

Cloud you please explain what is your requirement.I didn't get what you trying to explain.

Thanks,

Re: How to iterate on multiple components after 1 component

Anonymous — Fri, 01 Nov 2019 12:33:29 GMT

HDR

ID | NAME |

1

Based on ID (1 ) i ll query CHILD_TABLE

CHILD_TABLE

ID | HDR_ID | ETC
90 1 CAR
91 1 BIKE
92 1 FRUIT

i need to query Car,bike and fruit in iteration fashion as input to multiple other sources as output of tdbinput allows only 1 iterate link as output

Re: How to iterate on multiple components after 1 component

Aravind_Ravi — Fri, 01 Nov 2019 13:11:00 GMT

You can do something like this.

Oracleinput1 (MainTable)-> iterate -> Oracleinput2 (child_1) -> main -> tFlowToIterate -> and multiple Inputs DB

PFA the Screen shot

If this is what you are looking for then, Press the "Accept as Solution " Button.

Thanks,
AR

Multiple_Iterate.png