Mapping the input and output schemas - 7.3

ELT Hive

Version
7.3
Language
English
Product
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 Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > ELT components > ELT Hive components
Data Quality and Preparation > Third-party systems > ELT components > ELT Hive components
Design and Development > Third-party systems > ELT components > ELT Hive components
Last publication date
2024-02-21

Procedure

  1. Right-click ELTMap and select Link > *New Output* (Table) from the contextual menu.
  2. Click TotalScoreOfPreferredSubject. In the pop-up dialog box, click Yes to get the schema from the target component.
  3. Click ELTMap to open its Basic settings view.
  4. Select Repository from the Property Type drop-down list. Specify the Oracle database you previously added to automatically propagate the database connection information.
  5. Click [...] next to ELT Oracle Map Editor to open its map editor.
  6. 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.
  7. 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.
  8. 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.
  9. 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.
  10. Click OK to validate these changes and close the map editor.