Reputation: 511
I´ve a mysql statement which retrieves a lot of data from a table via the tMysqlInput component. Now I want to process the data in different ways and then merge them back again to a single output of the job.
Therefore I wanted to use the tReplicate component to avoid multiple requests to my SQL server. But if I´m using tReplicate I´m not able to map the two datastreams afterwards again with tMap.
Is there any other way to reuse the result of a mySql component multiple times?
Thanks in advance, Michael
Upvotes: 0
Views: 89
Reputation: 184
You can use tHashOutput to save the data from mysql and then use tHashInput to read that data and use in tMap.
Upvotes: 1