Property
| Description
|
---|---|
Connection
| Name of the target connection.
You can select an existing connection, create a new connection, or define parameter values for the target connection property.
If you want to overwrite the target connection properties at runtime, select the
Allow parameter to be overridden at run time option.
|
Target Type
| Type of the Oracle target object available. You can choose from the following target types:
|
Parameter
| A parameter file where you define values that you want to update without having to edit the task.
New Parameter to define a new parameter for the target object.
The
Parameter property appears only if you select parameter as the target type.
If you want to overwrite the target object at runtime, select the
Allow parameter to be overridden at run time option.
When the task runs, the Secure Agent uses the parameters from the file that you specify in the advanced session properties.
|
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:
|
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 task, you can use the Oracle bulk API to perform insert operation.
|
Pre SQL
| Pre-SQL command to run against the target database before writing data to the target.
|
Post SQL
| Post-SQL command to run against the target database after writing data to the target.
|
Update Override
| An update SQL statement that updates the data in an Oracle target table.
The update SQL statement you specify overrides the default update statements that the Secure Agent generates to update the target based on key columns. You can define an update override statement to update target tables based on both key or non-key columns. You cannot validate the update SQL statement in the SQL transformation.
In the override statement, you must enclose all reserved words in quotation marks.
|
Reject File Directory
| The directory that stores the rejected files.
Specify the directory where you want to store the rejected files.
|
Reject File Name
| Name of the rejected file that is stored in the reject file directory.
|
Schema Name
| Overrides the schema name of the target object.
|