Configuring the 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. Click the three-dot button next to ELT Mysql Map Editor or double-click the tELTMysqlMap component on the design workspace to launch the ELT Map editor.
    With the tELTMysqlMap component connected to the output component, the output table is displayed in the output area.
  2. Add the input tables, employees and dept, in the input area by clicking the green plus button and selecting the relevant table names in the Add a new alias dialog box.
  3. Create an alias table based on the employees table by selecting employees from the Select the table to use list and typing in Managers in the Type in a valid alias field in the Add a new alias dialog box.
  4. Drop the DeptNo column from the employees table to the dept table.
  5. Select the Explicit join check box in front of the DeptNo column of the dept table to set up an inner join.
  6. Drop the ManagerID column from the employees table to the ID column of the Managers table.
  7. Select the Explicit join check box in front of the ID column of the Managers table and select LEFT OUTER JOIN from the Join list to allow the output rows to contain Null values.
  8. Drop all the columns from the employees table to the corresponding columns of the output table.
  9. Drop the DeptName and Location columns from the dept table to the corresponding columns of the output table.
  10. Drop the Name column from the Managers table to the ManagerName column of the output table.
  11. Click on the Generated SQL Select query tab to display the SQL query statement to be executed.