When you configure a mapping task, you can configure advanced properties for Db2 Warehouse on Cloud targets.
Db2 Warehouse on Cloud Sources in Mapping Tasks
For Db2 Warehouse on Cloud source connections used in template-based mapping tasks, you can configure advanced properties in the Sources page.
The Sources page appears only if you defined a parameter for the source connection or object in the mapping. If you defined a connection parameter, select or create the specific connection that you want the mapping task to use. If you defined a source object parameter, select the mapping for a specific source object.
You can configure the following advanced properties:
Property
Description
Pre-SQL
The pre-SQL commands to run a query before you read data from IBM Db2 Warehouse.
Post-SQL
The post-SQL commands to run a query after you write data to a target.
Tracing Level
Sets the amount of details that appear in the log file.
You can choose terse, normal, verbose initialization, or verbose data. Default is normal.
Db2 Warehouse on Cloud Targets in Mapping Tasks
For Db2 Warehouse on Cloud target connections used in mapping tasks, you can configure advanced target properties in the Targets page of the Mapping Task wizard.
The Targets page appears only if you defined a parameter for the target connection or object in the mapping.
You can configure the following advanced target properties:
Property
Description
Update Mode
Specifies the mode to write data to IBM Db2 Warehouse target.
You can specify the following modes:
- Update As Update. Updates all rows flagged for update if the entries exist.
- Update Else Insert. Updates all rows flagged for update if the entries exist in the target. If the entries do not exist, the Secure Agent inserts the entries.
Truncate Target
The Secure Agent truncates the target before writing the data.
Pre-SQL
The pre-SQL commands to run a query before you read data from a source.
Post-SQL
The post-SQL commands to run a query after you write data to IBM Db2 Warehouse.
Forward Rejected Rows
Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows. By default, the agent forwards rejected rows to the next transformation.