Skip to main content


Dynamic Lookup in Talend

Woman, Cyber Security And Iot With Technology For Team, Meeting Or Programming Working At Night With Digital Overlay. Group Of Female Employee Developers Code, App Or Big Data In Futuristic Network

This article covers how to achieve dynamic lookup in Talend and get the updated data in the target.

 In order to get the new data after join execution we can use Reload at each row lookup model in tmap. The lookup data flow will update constantly and load the new lookup data for each record of main flow.

Create a job in Talend tool. In this example used the employee and state tables to demonstrate dynamic lookup logic. Connect the employee data as Main input and state data as lookup input to the tMap.


In tMap configure the Lookup model to Reload at each row and join the primary key of empid from employee table with empid from state table. In tMap output fetch the columns whatever needed in the output.


Run the job and update the value of any column of the lookup table. For example, after running the job, updated the state table of the column city from ‘Boston’ to ‘Olympia’ for empid=95






In output table -employee_tgt for the empid=95 we have got the latest data ie city=Olympia.


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Meena Mahendran

Meena Mahendran is Technical Consultant at Perficient. She is an expert in the Talend ETL tool.

More from this Author

Follow Us