Developer Transformation Guide

10.2.1
- 10.5.2
- 10.5
- 10.4.0
- 10.2.2 Service Pack 1
- 10.2.2

Anterior Siguiente

Advanced Properties

Configure advanced properties to determine how the Data Integration Service processes data for the Write transformation.

Configure the following properties on the Advanced tab:

Tracing level: Control the amount of detail in the mapping log file.
Target load type: Type of target loading. Select Normal or Bulk. You can set the target load type for relational resources or customized data objects.
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.
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
Update override: Overrides the default UPDATE statement for the target.
Delete: Deletes all rows flagged for delete.; Default is enabled.
Insert: Inserts all rows flagged for insert.; Default is enabled.
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.
Truncate target table: Truncates the target before it loads data.; Default is enabled.
Truncate target partition: Truncates an internal or external partitioned Hive target before it loads data. You must choose
Truncate target table
before you choose this option.; Default is disabled.
Update strategy: Update strategy for existing rows. You can select one of the following strategies:
Update as update. The Data Integration Service updates all rows flagged for update.
Update as insert. The Data Integration Service inserts all rows flagged for update. You must also select the
Insert
target option.
Update else insert. The Data Integration Service updates rows flagged for update if they exist in the target and then inserts any remaining rows marked for insert. You must also select the
Insert
target option.
PreSQL: SQL command the Data Integration Service runs against the target database before it reads the source.; The Developer tool does not validate the SQL.
PostSQL: SQL command that the Data Integration Service runs against the target database after it writes to the target.; The Developer tool does not validate the SQL.
Maintain row order: Maintain the row order of the input data to the target. Select this option if the Data Integration Service should not perform any optimization that can change the row order.; When the Data Integration Service performs optimizations, it might lose the row order that was established earlier in the mapping. You can establish row order in a mapping with a sorted flat file source, a sorted relational source, or a Sorter transformation. When you configure a target to maintain row order, the Data Integration Service does not perform optimizations for the target.
Constraints: SQL statements for table-level referential integrity constraints. Applies to relational targets only.

Propiedades de la transformación de escritura

Descargar guía

Enviar comentarios

Communities

Knowledge Base

Success Portal

Rename Saved Search

Índice

Developer Transformation Guide

Developer Transformation Guide

Advanced Properties

Advanced Properties