OWB - Pre-mapping process operator

> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder

1 - About

Use a Pre-Mapping Process operator to define a procedure to be executed before running a mapping. To use a Pre-Mapping Process operator in a mapping, Drag and drop a Pre-Mapping Process operator onto the Mapping Editor canvas.

For example, you can use a Pre-Mapping Process operator to :

  • truncate tables in a staging area before running a mapping that loads tables to that staging area.
  • disable indexes before running a mapping that loads data to a target.

And you can then use a post-mapping_process_operator to reenable and build the indexes after running the mapping that loads data to the target.

Advertising

3 - Rules

  • A mapping can only contain one Pre-Mapping Process operator.
  • Only constants, mapping input parameters, and output from a Pre-Mapping Process can be mapped into a Post-Mapping Process operator.

4 - Properties

After you add a Pre-Mapping Process operator to the Mapping Editor, use the operator property dialog box to specify conditions in which to execute the mapping.

To set run conditions for a mapping with a Pre-Mapping Process operator:

  1. In the mapping canvas, select the Pre-Mapping Process operator.
  2. The Pre-Mapping Process Properties panel displays the properties of the Pre-Mapping Process operator.

Mapping Run Condition :

  • Always: Runs the mapping after the process completes, regardless of the errors.
  • On Success: Runs the mapping only if the process completes without errors.
  • On Error: Runs the mapping only if the process completes with errors.

Row Base Only :

  • Indicates if this transformation must be used only Row Based mode. Some transformations can be used in SQL mode as well as Row Based mode.
Advertising