Db2 Warehouse on Cloud Connector

Back Next

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.