Connecting a tMap component using OnComponentOK connection in Talend

Question

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.

Answer 1

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:

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") + "';

Hope this helps!

To know more about Talend, join Talend for big data certification training today.

Thanks.