Oracle Connector Guide > Mappings and Mapping Configuration Tasks with Oracle Connector > Oracle Targets in Mappings
  

Oracle Targets in Mappings

To write data to an Oracle target, configure an Oracle object as the Target transformation in a mapping. Specify the name and description of the Oracle target.
The following table describes the properties that you can configure for an Oracle target:
Property
Description
Connection
Name of the target connection.
Target Type
Type of the target object. Select Single Object or Parameter.
Object
Name of the Oracle target object. Select target object for a single target or primary target object for multiple targets.
You can select an existing object from the list or create a target in run time.
Operation
Target operation. Select Insert, Update, Delete, or Data Driven.
Truncate target
Database targets with the Insert task operation. Truncates a database target table before inserting new rows.
Truncates the target table before inserting all rows, if you select the check box.
Inserts new rows without truncating the target table, if you clear the check box.
By default, the check box is clear.
You can also configure an Oracle target advanced property Forward Rejected Rows.
The Data Integration Service flags the rows for reject and writes them to the session reject file if you select the Forward Rejected Rows check box. The Data Integration Service drops rejected rows and writes them to the session log file if you do not select Forward Rejected Rows check box.