Procedure
- Connect the two tELTMysqlInput components to the tELTMysqlMap component using Link connections named strictly after the actual input table names, employees and dept in this use case.
- Connect the tELTMysqlMap component to the tELTMysqlOutput component using a Link connection. When prompted, click Yes to allow the ELT Mapper to retrieve the output table structure from the output schema.
-
Click the tELTMysqlMap component and
select the Component tab to display its
Basic settings view.
-
Select Repository from the Property Type list, and select the same DB
connection that you use for the input components.
All the DB connection details are automatically retrieved.Note: Leave all the other parameters as they are.