The following image shows the

Connect Target

page:

To create a target connection, click

New Connection

. You can also select an existing connection. After you choose the connection, you might have to configure additional properties like

Write Disposition

and

Staging Location

that vary based on the connection type.

The first time you run a

data loader

task, the task creates one target table for each source object. By default, target table names are the same as the source object names. However, special characters in the source table names will be replaced with underscore characters. For example, if the source table name is

Orders$

, the corresponding target table will be named

Orders_

.

If you enter a target name prefix, the target object names will be the same as the source object names, but they'll be preceded with the prefix. For example, if a source table name is

Account

, and you enter the prefix

tgt_

, the target table name will be

tgt_Account

.

When you re-run a task, you can either load data to the target incrementally or drop and re-create the target tables.