Building a Job

Procedure

Drop two tELTMysqlInput components, a tELTMysqlMap component, and a tELTMysqlOutput component to the design workspace, and label them to best describe their functionality.
Double-click the first tELTMysqlInput component to display its Basic settings view.
Select Repository from the Schema list, and define the DB connection and schema by clicking the three dot button preceding Edit schema.

The DB connection is Talend_MySQL and the schema for the first input component is employees.

Information noteNote:
In this use case, all the involved schemas are stored in the Metadata node of the Repository tree view for easy retrieval. For further information concerning metadata, see Managing metadata in Talend Studio.
Set the second tELTMysqlInput component in the same way but select dept as its schema.
Double-click the tELTMysqlOutput component to display its Basic settings view.
Select an action from the Action on data list as needed, Insert in this use case.
Select Repository as the schema type, and define the output schema in the same way as you defined the input schemas. In this use case, select result as the output schema, which is the name of the database table used to store the mapping result.

The output schema contains all the columns of the input schemas plus a ManagerName column.

Information noteNote: Leave all the other parameters as they are.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!