- 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.