Overwrites the partition in the Hive target in which the data is being inserted. To enable this option, you must also select the option to truncate target tables.

You can truncate external partitioned tables and non-partitioned tables.

Default is disabled.

Type of target loading. Select Normal or Bulk.

If you select Normal, the Data Integration Service loads targets normally. You can choose Bulk when you load to DB2, Sybase, Oracle, or Microsoft SQL Server. If you specify Bulk for other database types, the Data Integration Service reverts to a normal load. Bulk loading can increase mapping performance, but it limits the ability to recover because no database logging occurs. When you write to an Oracle target with bulk loading, you can optimize performance by disabling constraints in the Oracle database.

Choose Normal mode if the mapping contains an Update Strategy transformation. If you choose Normal and the Microsoft SQL Server target name includes spaces, configure the following environment SQL in the connection object:

SET QUOTED_IDENTIFIER ON

Overrides the default UPDATE statement for the target.

Deletes all rows flagged for delete.

Default is enabled.

Inserts all rows flagged for insert.

Default is enabled.

Type of target schema strategy for the relational or Hive target table.

You can select one of the following target schema strategies:

RETAIN - Retain existing target schema. The Data Integration Service retains the existing target schema.
CREATE - Create or replace table at run time. The Data Integration Service drops the target table at run time and replaces it with a table based on a target table that you identify.
Assign Parameter. You can assign a parameter to represent the value for the target schema strategy and then change the parameter at run time.

This option is applicable when you select the

CREATE - Create or replace table at run time

target schema strategy.

Truncates the target before it loads data.

Default is disabled.

Update strategy for existing rows. You can select one of the following strategies:

SQL command the Data Integration Service runs against the target database before it reads the source. The Developer tool does not validate the SQL.

SQL command the Data Integration Service runs against the target database after it writes to the target. The Developer tool does not validate the SQL.