How to combine 2 streams in Talend

Anonymous — Thu, 01 Feb 2018 13:25:16 GMT

Hi Folks,

I want to know how to combine 2 streams and push it to database.

Please refer the screen shot. I want to combine tAgreegateRow_1 to tMap3, all club this output individually and pass it to database.

Re: How to combine 2 streams in Talend

TRF — Thu, 01 Feb 2018 22:31:44 GMT

Hi,
This is just not possible to merge 2 flows issued from a tReplicate or a tMap in the same subjob where they have been created.
You need store the tAggregateRow result into a tHashOutput or a file if you prefer.
You also need to replace the tMySQLOutput by a tHashOutput.
Then, start a new subjob by a tHashInput associated to one of the tHashOutput connected to the tFileList component by an onSubjobOk trigger.
Finally, connect this flow to a tMap. Connections a 2nd tHashInput associated to the other tHashOutput as a lookup and push the result from the tMap to your tMySQLOutput.
Hope this help.

topic How to combine 2 streams in Talend in Talend Studio

How to combine 2 streams in Talend

Re: How to combine 2 streams in Talend