Connecting a tMap component using ‘OnComponentOK’ connection in Talend

0 votes

I have a job where I need to extract a specific timestamp from the database and then based on that timestamp, further I need to process 3 more database tables. Finally, I need to map all the data coming from the database input components and map them to accumulate them in a delimited file. Can someone help me in linking the first database input component with tMap using ‘OnComponentOK’ link? I am not able to do it as rest of the database input components as dependent on the first one.

Apr 23, 2018 in Talend by misc.edu04
• 1,380 points
343 views

1 answer to this question.

0 votes

I think you don’t need to use the “OnComponentOk” link in this scenario.

Rather what you can do is, arrange your components as shown in the below diagram:

image

Once done with arranging the components, you will get two Subjobs. One will retrieve and store the global variable. The second job will retrieve and map data based on the global variable.

To perform the job go to the tSetGlobaVar and specify the timestamp pattern to your date variable. After this, go to the tMysqlInput Components and specify provide the global variables reference as shown below:

SELECT ... 

FROM ... 

WHERE mydate >= '" + (String) globalMap.get("myDate") + "';
answered Apr 23, 2018 by code.reaper12
• 3,450 points

Related Questions In Talend

0 votes
1 answer

Parameterizing a tOracleInput component using Talend

I think you should use context variables. ...READ MORE

answered Apr 18, 2018 in Talend by geek.erkami
• 2,320 points
126 views
0 votes
1 answer

Connecting tJIRAOutput component using Talend

Your entire configuration is correct apart from ...READ MORE

answered Apr 19, 2018 in Talend by geek.erkami
• 2,320 points
112 views
0 votes
1 answer
0 votes
1 answer

Using tHiveRow to execute multiple Hive queries in Talend

In order to execute multiple queries, you ...READ MORE

answered Apr 14, 2018 in Talend by misc.edu04
• 1,380 points
571 views
0 votes
1 answer

tWaitForFile component insufficiency in Talend

Regarding your first issue, tWaitForFile component provides ...READ MORE

answered Apr 10, 2018 in Talend by geek.erkami
• 2,320 points
220 views
0 votes
1 answer
0 votes
1 answer

Closed loop in Talend

As you might know,  in Talend all ...READ MORE

answered Apr 19, 2018 in Talend by code.reaper12
• 3,450 points
258 views
0 votes
2 answers
0 votes
1 answer

How to load a set of files into database using Talend

Using tFileList component,  you can read all the files present ...READ MORE

answered Apr 16, 2018 in Talend by code.reaper12
• 3,450 points
428 views