Tasks

Back Next

Configuring targets

The

Targets

page displays differently depending on the basis for the task.

For mappings, 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 example, if the target is parameterized but the connection is not, you must specify a target and you can optionally change the connection.

All of the properties display in one list, even when the task includes multiple objects. Place your the cursor over the properties to determine which objects the properties apply to. For example, in the following image, the

Enable target bulk load

parameter applies to the target named

TargetSQLAllCust

For Visio templates, the

Targets

page can display connection and template parameters for targets, lookups, and stored procedures, as well as mapplets that contain lookups.

Note the following additional information about template parameters:

The connection and object names that display are based on the template parameter names in the Visio template.

For a mapplet, you select a connection. You do not select objects for mapplets.

When a connection name displays without surrounding dollar signs, it is a logical connection. If the logical connection is associated with multiple objects on the

Targets

page, you select the logical connection once, and then select each object.

If the logical connection is associated with objects on other pages of the task wizard, be sure to use the same connection for logical connections with the same name.

When you select an object, the

Data Preview

area displays a portion of the data in the object. For a flat file connection, data preview displays all of the columns and the first ten rows of the object. For other connection types, data preview displays the first ten rows of the first five columns in the object. It also displays the total number of columns in the object.

If the page has more than one object, you can select the object in the

Data Preview

area to display its data.

Data preview does not display the following types of data:

Mapplet data.

Certain Unicode characters.

Binary data. If the object contains binary data, data preview shows the following text:

BINARY DATA

On the

Targets

page, configure the following details as required:

Target parameter detail	Description
Connection	Select a connection. For a Visio template, the list of available connections depends on the connections associated with the selected runtime environment and the connection types allowed by the Visio template. To create a connection, click New . To edit a connection, click View , and in the View Connection dialog box, click Edit .
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. To configure advanced properties for the target, click Advanced . Not available for all connection types. The properties available vary based on the connection type. When you edit advanced properties, you can restore the default values for individual properties or for all 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. Object field names cannot start with a number.
Display Technical Field Names Instead of Labels	Displays technical names instead of business names. Not available for all connection types.
Display Target Fields in Alphabetical Order	Displays target fields in alphabetical order. By default, fields appear in the order returned by the target system.
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.
Create Target	For flat file and relational database connections only. Creates a target file. Enter a name for the target file. If you want the file name to include a time stamp, select Handle Special Characters and add special characters to the file name, for example, Accounts_%d%m%y%T.csv .

For a task based on a Visio template, configure the following details if necessary:

Lookup details. This displays when a lookup requires a connection or object, and the lookup is configured to display on this page. If you need to select a lookup object, select the object from the list. If a list does not display, click

Select

Mapplet details. This displays when a mapplet requires a connection and the mapplet is configured to display on this page.

Stored procedure details. This displays when a stored procedure requires a connection and the stored procedure is configured to display on this page.

For a task based on a mapping, you define these properties in the mapping.

Click

Mapping task configuration with Visio templates

Download Guide

Watch

Comments

Cloud Data Integration Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Tasks

Tasks

Configuring targets

Configuring targets