Alternatively, you can define a parameter, and then specify the connection in the mapping task.

If you select a single object, you can also preview the data.

Applies to insert and data driven operations.

Use the bulk API to write large amounts of data to the database with a minimal number of API calls. Loading in bulk mode can improve performance, but it limits the ability to recover because no database logging occurs.

Applies to insert operations.

Applies to update, upsert, delete and data driven operations.

For example, the following IIF statement flags a row for reject if the ID field is null. Otherwise, it flags the row for update:

IIF (ISNULL(ID), DD_REJECT, DD_UPDATE )

Applies to the data driven operation.

If you do not forward rejected rows, the

mapping

task drops rejected rows and writes them to the session log.

If you enable row error handling, the

mapping

task writes the rejected rows and the dropped rows to the row error logs instead of generating a reject file. If you want to write the dropped rows to the session log in addition to the row error logs, you can enable verbose data tracing.

You can enter a command of up to 5000 characters.

You can enter a command of up to 5000 characters.

Enter the update statement. Alternatively, click

Configure

to generate the default UPDATE statement, and then modify the default statement.

The UPDATE statement that you enter overrides the default UPDATE statement that

Data Integration

uses to update targets based on key columns. You can define an override UPDATE statement to update target tables based on non-key columns.

If you specify both the directory and file name in the

Reject File Name

field, clear this field. The

mapping

task concatenates this field with the

Reject File Name

field when it runs the task.

The

mapping

task concatenates this field with the

Reject File Directory

field when it runs the task. For example, if you have

C:\reject_file\

in the

Reject File Directory

field, and enter

filename.bad

in the

Reject File Name

field, the

mapping

task writes rejected rows to

C:\reject_file\filename.bad

.