Mapping the input and output schemas

Procedure

Right-click ELTMap and select Link > *New Output* (Table) 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 editor.
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 TotalScore.
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 table TotalScore.
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 output table.
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 output table.
Click the Generated SQL Select query for "table2" output tab at the bottom of the map editor to display the corresponding generated SQL statement.

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 editor.

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!

Leave your feedback here