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.
- 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.
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:
- In the mapping canvas, select the Pre-Mapping Process operator.
- 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.