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.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!
