Tasks

Back Next

Configuring targets

The

Targets

page displays differently depending on the basis for the task.

The

Targets

page displays when the mapping includes parameters for target connections or target objects. The properties that you need to specify are based on the type of parameter.

For each target parameter, configure the following details:

Target parameter detail	Description
Connection	Select a connection. To create a connection, click New . To edit a connection, click View , and in the View Connection dialog box, click Edit . Hover over the target connection tool tip to view more information about the connection.
Object	Select a target object. If a list of objects does not appear, 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. Hover over the target object tool tip to view more information about the object.
Operation	Target operation, either insert, update, upsert, delete, or data driven. Not editable for all connection types.
Truncate target	Truncates the target object before inserting new rows. Applies to insert and data driven operations. Not available for all connection types.
Enable target bulk load	Uses the database bulk API to perform an insert operation. 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. Not available for all connection types.
Display technical names instead of labels	Displays technical names instead of business names. Not available for all connection types.

Configure formatting options if required.

The properties available vary based on the connection type. For information about a particular connector's properties, see the help for the appropriate connector.

Optionally, expand the

Data Preview

area to preview the data.

To display fields in alphabetical order, click

Display mapplet fields in alphabetical order

. By default, fields appear in the order returned by the target system.

To download the preview results, click

Download

Configure field metadata if required.

You can configure field metadata for targets with certain connection types. To see if a connector supports field metadata configuration, see the help for the appropriate connector.

You can't update field metadata in mapping tasks that are based on mappings in SQL ELT mode.

To edit field metadata, expand the

Field Data Types

area and select the row that contains the field that you want to edit. Configure the following attributes:

Data type attribute	Description
Retain existing fields at runtime	When enabled, the task uses the field metadata that is configured in the task. If field metadata changes after a task is saved, Data Integration uses the updated field metadata. Typically, this is the desired behavior. However, if the task uses a flat file connection and you want to retain the metadata used at design time, enable this option.
Type	The data type of the field.
Precision	Total number of digits in a number. For example, the number 123.45 has a precision of 5. The precision must be greater than or equal to 1.
Scale	Number of digits to the right of the decimal point of a number. For example, the number 123.45 has a scale of 2. Scale must be greater than or equal to 0. The scale of a number must be less than its precision. The maximum scale for a numeric data type is 65535. Not editable for all data types.

Optionally, configure advanced options for the selected connection.

The options available depend on the connection.

When you edit advanced options, you can restore default values for individual properties or for all advanced properties. Default values are defined in the mapping that the task is based on.

For information about a particular connector's properties, see the help for the appropriate connector.

Click

Mapping task configuration

Download Guide

Watch

Comments

Cloud Data Integration Homepage