Combining two flows for selective output

In this scenario, a flow generated by tFixedFlowInput is combined with a flow from the Mysql database. The source flow contains id and age fields while the Mysql table contains id and name. We want to retrieve the age data of the source flow and combine it with the id and name records from the Mysql table based on id matching. One thing that is worth noting is that the input schema is different from the output one at tMysqlRow in the Job.

For more technologies supported by Talend, see Talend components.