Configuring the Job - 7.2

ELT Oracle

Version
7.2
Language
English (United States)
Product
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
Module
Talend Studio
Content
Data Governance > Third-party systems > ELT components > ELT Oracle components
Data Quality and Preparation > Third-party systems > ELT components > ELT Oracle components
Design and Development > Third-party systems > ELT components > ELT Oracle components

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 [+] button on the upper left corner and selecting the relevant table names in the pop-up dialog box.
  3. Create an alias table based on the employees table by clicking the [+] button on the upper left corner, selecting employees from the drop-down list and typing in Managers in the field in the pop-up 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.