Skip to main content Skip to complementary content

Configuring the Job

Procedure

  1. Click the [...] 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.

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!