#1 2012-05-11 14:26:06

samron
New member
Registered: 2012-02-09
Posts: 6

Save the result of a query

Tags: [database]

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)

Offline

#2 2012-05-12 04:26:12

shong
Talend team
Registered: 2007-08-29
Posts: 10310
Website

Re: Save the result of a query

Hi
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:

tMysqlInput--main---tMysqlOutput

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

Board footer

Powered by FluxBB