One Star

store the result of a query in a global variable

Hello,
I want to make a join between a table in oracle and a table in mysql.
I use the map component with talend to make this join.
My problem is that I have to make this join 3 times between my table oracle and my table mysql (3 couples of ID in my oracle table). I have created a 3 input Mysql on my table and I link these input with the map. But it's not a good solution because I make 3 select on the mysql table for the same result.... I cannot use the replicat component because I have one result and not three result.
So I want to make the select on the mysql table, store this result in a variable and use this result 3 times.
Does anybody have a solution on this problem ? Can I use a talend component for this behaviour ?
Thanks
2 REPLIES
One Star

Re: store the result of a query in a global variable

no idea ?
One Star

Re: store the result of a query in a global variable

hi,
i don't understand, can you put some screenshot of what you have already done ?