Mapping the input and output schemas - 6.4

ELT Oracle

author
Talend Documentation Team
EnrichVersion
6.4
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > ELT components > ELT Oracle components
Data Quality and Preparation > Third-party systems > ELT components > ELT Oracle components
Design and Development > Third-party systems > ELT components > ELT Oracle components
EnrichPlatform
Talend Studio

Procedure

  1. 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.
  2. Click ELTMap to open its Basic settings view.
    Fill in the Host, Database, Username, and Password fields with the Teradata database connection information.
  3. Click the [...] button next to ELT Teradata Map Editor to open its map editor.
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. Click OK to validate these changes and close the map editor.