devista
devista

Reputation: 55

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.

Upvotes: 1

Views: 458

Answers (1)

dbh
dbh

Reputation: 1627

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 .

Upvotes: 1

Related Questions