Mapping the input and output schemas - 7.2

ELT Greenplum

author
Talend Documentation Team
EnrichVersion
7.2
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 Real-Time Big Data Platform
task
Data Governance > Third-party systems > ELT components > ELT Greenplum components
Data Quality and Preparation > Third-party systems > ELT components > ELT Greenplum components
Design and Development > Third-party systems > ELT components > ELT Greenplum components
EnrichPlatform
Talend Studio

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.