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).
- Go to the Component View.
- Select the "Basic settings" tab.
- Scroll down and find the "Action on data" setting.
- Choose the action (Replace, Insert or Update, etc.).
|Specifying Action in Talend|