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. Configure the target and advanced properties for the target object.
The following table describes the properties that you can configure for an Oracle target:
Property | Description |
|---|
Connection | Name of the active Oracle target connection. |
Target Type | Type of the Oracle target object available. You can choose from the following target types: |
Object | You can select an existing object from the list or create a target at run time. |
Operation | Select the target operation. You can perform the following operations on an Oracle target: - - Insert
- - Update
- - Upsert
- - Delete
- - Data Driven
|
Truncate target | When you enable the Truncate Target option, the Secure Agent truncates the table. Default is false. |
Enable Target Bulk Load | Uses Oracle bulk API to insert data in bulk mode. When you create a Mapping Configuration task, you can use the Oracle bulk API to perform insert operations. Default is unselected. |
If you select the Forward Rejected Rows option, the Secure Agent flags the rows for reject and writes them to the reject file. If you do not select the Forward Rejected Rows option, the Secure Agent drops rejected rows and writes them to the session log file. The Secure Agent does not write the rejected rows to the reject file.
Note: If there is an error row when you run a task to write files to an Oracle target in bulk mode, the Secure Agent writes the batch that contains the error row in normal mode.