Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
Cloud you please explain what is your requirement.I didn't get what you trying to explain.
Thanks,
AR
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
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