-
Right-click ELTMap, select Link > *New Output*
(Table) from the contextual menu and 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.
Fill in the Host, Database, Username, and
Password fields with the Teradata database
connection information.
-
Click the [...] button next to ELT Teradata 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.
Do the same 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.
Do the same for the Subject column.
-
Drag the SeqID column in the input table
PreferredSubject and drop it to the
corresponding column in the output table.
Do the same 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 ELTSubqueryMap 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.
Fill in the Host, Database, Username, and Password fields with the Teradata database connection information.
The SQL query generated in the ELTSubqueryMap 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.