Tasks

Back Next

Configuring the target

You can write data to a single target. You can select an existing target object or create a new object at run time. If you create a target at run time, the task operation is Insert.

On the

Target

page, configure the following properties as required:

Property	Description
Connection	Select a connection. To create a connection, click New . To edit a connection, click View , and the in View Connection dialog box, click Edit . To configure advanced properties for the connection, click Advanced Options . Not available for all connections types. For information about a particular connector's properties, see the help for the appropriate connector.
Object	Select a target object. Click Select . The Select Target Object dialog box displays up to 200 objects. If the object you want to use does not display, enter a search string to reduce the number of objects that display.
Target operation	Select one of the following task operations: Insert Update Upsert Delete Data Driven The operations available depend on the target connection.
Formatting Options	For flat file and FTP/SFTP connections only. Select a delimiter and text qualifier. Optionally, select an escape character. If you choose Other for the delimiter, the delimiter cannot be an alphanumeric character or a double quotation mark. If you choose a delimiter for an FTP/SFTP flat file, Data Integration applies the delimiter to the local file, not the remote file, when previewing and reading data. If the remote and local files are not synchronized, you might see unexpected results.
Truncate Target	Database targets with the Insert task operation only. Truncates a database target table before inserting new rows. True. Truncates the target table before inserting all rows. False. Inserts new rows without truncating the target table. Default is False.
Enable Target Bulk Load	Select this option to write data in bulk mode. The default value is false.