How to combine 2 streams in Talend

Six Stars

How to combine 2 streams in Talend

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.

Sixteen Stars TRF
Sixteen Stars

Re: How to combine 2 streams in Talend

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.

TRF

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog