In this pipeline, the records from two different input streams are merged into a MySQL table using the MySQL Merge Snap. The upstream input from the Mapper Snap and the CSV Generator Snap are joined by the Join Snap. The new MySQL table will now have the records with columns passed from both the input sources.

The MySQL Select Snap retrieves the records from the table, pqadb.TAM_SAMPLE_PERSONS to be merged into a table pqadb.TAM_SAMPLE_PERSONS_MERGE.