Right-click ELTMap and select from the contextual menu.
Click TotalScoreOfPreferredSubject. In the pop-up dialog box, click
Yes to get the schema
from the target component.
Click ELTMap to open its Basic settings view.
Select Repository from
the Property Type drop-down list. Specify the Oracle database you previously
added to automatically propagate the database connection information.
Click [...] next to ELT Oracle Map Editor to open its map
Add the input table PreferredSubject by clicking the [+] button in the upper left corner of the map
editor and selecting the relevant table name from the drop-down list in the
pop-up dialog box.
Repeat the step to add another input table
Drag the StuName column in the input table
PreferredSubject and drop it to the corresponding column in the
input table TotalScore. Then select the
Explicit join check
box for the StuName column in the input
Repeat the step for the Subject column.
Drag the SeqID column in the input table PreferredSubject and drop it to the corresponding column in the
Repeat the step to drag the StuName and Subject columns in the input table PreferredSubject and the Score column in the input table TotalScore and drop them to the corresponding column in the
Click the Generated SQL Select query for "table2" output
tab at the bottom of the map editor to display the corresponding generated SQL
The SQL query generated in the SubqueryMap component appears as a subquery in
the SQL query generated by this component. Alias will be automatically added for
the selected columns in the subquery.
Click OK to validate these changes and close the map