Procedure
-
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.
- 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.
- 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.
- Drop the DeptNo column from the employees table to the dept table.
- Select the Explicit join check box in front of the DeptNo column of the dept table to set up an inner join.
- Drop the ManagerID column from the employees table to the ID column of the Managers table.
-
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.
- Drop all the columns from the employees table to the corresponding columns of the output table.
- Drop the DeptName and Location columns from the dept table to the corresponding columns of the output table.
-
Drop the Name column from the Managers table to the ManagerName column of the
output table.
-
Click on the Generated SQL Select query
tab to display the SQL query statement to be executed.