You are not logged in.
Hi, i'm not an expert in Talend and while i've done some jobs nothing of them it's very complex.
What i want to do is to save the result of a query. How can I achive this result?
In my previous job usually i build the select between the tables, but in this case i receive a query and i want to execute directly the query. Also i know i can specify a query on a table from the "Component" Window but from what i know i can make a select on the table itself - while my select it's about different tables
A the end, the result records of the query have to be insert in a MySql table
Thank for any help
Last edited by samron (2012-05-11 14:33:40)
You can execute the query in a tMysqlInput component even though the select involves different tables, and insert the result records into mysql table with tMysqlOutput, the job looks like: