Skip to main content Skip to complementary content

Adding 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.

Information noteNote:

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!