Property | Description |
|---|---|
Update Mode | Specifies the mode to write data to PostgreSQL target. You can specify the following modes:
|
Override Target Query | An SQL statement to override the default update query that the Secure Agent generates for the update operation. |
Schema Name | Overrides the schema name of the target object. |
Target Table Name | Overrides the default PostgreSQL target table name. |
Pre-SQL | The pre-SQL commands to run a query before you write data to PostgreSQL. You can partially parameterize pre-SQL with values specified in a parameter file. |
Post-SQL | The post-SQL commands to run a query after you write data to PostgreSQL. You can partially parameterize post-SQL with values specified in a parameter file. |
Truncate Target | The Secure Agent truncates the target before writing the data. |
Enable target bulk load | Performs bulk upload when you configure an insert operation to write to PostgreSQL. Select this option to improve the performance of inserting data in bulk to PostgreSQL. Default is unselected. Note: When you enable the target bulk mode to insert data to PostgreSQL, error files are not generated for rejected records. |
Batch size | The number of rows that the Secure Agent writes in a single batch to PostgreSQL. Specify a batch size value that is greater than zero. Applicable if you select the Enable target bulk load option. |
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. |
Forward Rejected Rows | Not applicable. |