OWB - Pre-mapping process operator

Card Puncher Data Processing

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.

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.

Pre Mapping Operator

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.





Discover More
Card Puncher Data Processing
OWB - Mapping

OWB - Mapping
Card Puncher Data Processing
OWB - Operators

The operators are used in a mapping to create a process and have several types : Source/Target Operators: These operators represent Oracle Database objects in the mapping. It also contains Flat File...



Share this page:
Follow us:
Task Runner