Adding components - 7.2

ELT Oracle

Version
7.2
Language
English (United States)
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 Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
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

As described in Aggregating table columns and filtering, configure a Job for data aggregation using the corresponding ELT components for Oracle database - tELTOracleInput, tELTOracleMap, and tELTOracleOutput. Execute the Job to save the aggregation result in a database table named Agg_Result.

Note:

When defining filters in the ELT Map editor, note that strings are case sensitive in Oracle database.

Procedure

  1. Launch the ELT Map editor and add a new output table named update_data.
  2. Add a filter row to the update_data table to set up a relationship between input and output tables: owners.ID_OWNER = agg_result.ID_OWNER.
  3. Drop the MAKE column from the cars table to the update_data table.
  4. Drop the NAME_RESELLER column from the resellers table to the update_data table.
  5. Add a model enclosed in single quotation marks, 'A8' in this use case, to the MAKE column from the cars table, preceded by a double pipe.
  6. Add Sold by enclosed in single quotation marks in front of the NAME_RESELLER column from the resellers table, with a double pipe in between.
  7. Check the Generated SQL select query tab to be executed.
  8. Click OK to validate the changes in the ELT Mapper.
  9. Deactivate the tELTOracleOutput component labeled Agg_Result by right-clicking it and selecting Deactivate Agg_Result from the contextual menu.
  10. Drop a new tELTOracleOutput component from the Palette to the design workspace, and label it Update_Data to better identify its functionality.
  11. Connect the tELTOracleMap component to the new tELTOracleOutput component using the link corresponding to the new output table defined in the ELT Mapper, update_data in this use case.
  12. Double-click the new tELTOracleOutput component to display its Basic settings view.
  13. From the Action on data list, select Update.
  14. Check the schema, and click Sync columns to retrieve the schema structure from the preceding component if necessary.
  15. In the WHERE clauses area, add a clause that reads agg_result.MAKE = 'Audi' to update data relating to the make of Audi in the database table agg_result.
  16. Fill the Default Table Name field with the name of the output link, update_data in this use case.
  17. Select the Use different table name check box, and fill the Table name field with the name of the database table to be updated, agg_result in this use case. Leave the other parameters as they are.