Search code examples
talend

Combining/ Merging all TMaps into a single table

I have the following talend job where each is an API call to get the currency exchange rate. The fields within each Tmap are: - FrommCurr - ToCurr (Each Tmap has a hardcoded string value "EUR", "USD", "CAD") - Date - DateTime

I would like to combine all of these into a single table before inserting. what is the object that will let me combine them? Or should I insert each single TMap into the database? The database, I will be inserting into is MSSQL.

Solution

  • As long As all the final tMap components produce exactly the same schema , you can join the output into a single stream of rows with tUnite .