Building a Job - 7.2

ELT Greenplum

author
Talend Documentation Team
EnrichVersion
7.2
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > ELT components > ELT Greenplum components
Data Quality and Preparation > Third-party systems > ELT components > ELT Greenplum components
Design and Development > Third-party systems > ELT components > ELT Greenplum components
EnrichPlatform
Talend Studio

Procedure

  1. Drop two tELTMysqlInput components, a tELTMysqlMap component, and a tELTMysqlOutput component to the design workspace, and label them to best describe their functionality.
  2. Double-click the first tELTMysqlInput component to display its Basic settings view.
  3. 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.

    Note:

    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 Talend Studio User Guide.

  4. Set the second tELTMysqlInput component in the same way but select dept as its schema.
  5. Double-click the tELTMysqlOutput component to display its Basic settings view.
  6. Select an action from the Action on data list as needed, Insert in this use case.
  7. 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.

    Note: Leave all the other parameters as they are.