OWB - Pre-mapping process operator

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 etl:owb:operator:post-mapping_process_operator to reenable and build the indexes after running the mapping that loads data to the target.

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.

Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap