talend open studio create tmap

Question

I want to select certain columns from 2 tables by coding the appropriate SQL code in the "query" zone of my tMySQLInput component. Then I've been told to use a "tMap" component in order to map each column from my tMySQLInput component to my tMySQLOutput component.

Is this the correct way to to do what I need to do : Take information (SELECT ...) from 2 tables and then insert them into another 3 rd table?

Googled it, got results for exactly this. Example 1: https://www.talendbyexample.com/talend-tmap-component-reference.html example 2: https://www.youtube.com/watch?v=20qJmOr5Uts example 3: https://mindmajix.com/talend/creating-tmap-expressions-using-tmap-component — tobi6, Nov 10 '17 at 16:32

score 0 · Accepted Answer · edited Dec 14 '17 at 07:34

Inorder to insert data from 2 tables (source) into another table(target), it is necessary to use tmap component.

1.tMysqlinput(with query) and check the edit schema section for appropriate values you wish to send to the output/target

2.tMap component map all the necessary columns from source to target

3.tMysqlOutput check the edit schema section for appropriate columns that you wish to see in your target.

talend open studio create tmap

1 Answers1