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
