Upsert or Replace with Talend

Some ETL tools mark a target for upsert or replace in the transformation action.  Talend uses the target itself.

This map loads a MySQL table (ATD_HOTEL) with the contents of an Excel spreadsheet joined with a MySQL table (ATD_CLIENT_HOTEL).  The Excel spreadsheet is the main driver while ATD_CLIENT_HOTEL is a lookup.  A tMap provides the transformation.

To define the action to take when the transformation is run (insert and fail on key violations, upsert, replace, etc.), select the target of the tMap (the MySQL output, ATD_HOTEL).

1. Go to the Component View. 
2. Select the "Basic settings" tab.
3. Scroll down and find the "Action on data" setting.
4. Choose the action (Replace, Insert or Update, etc.).

Specifying Action in Talend