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.