Tasks

Back Next

Configuring sources

The

Sources

page displays differently based on the basis for the task. If the mapping does not include source parameters, the

Sources

page might not appear.

You can add a single source object or multiple source objects based on the connection type and the mapping configuration. You can also configure a source filter.

After you configure the source, validate the configuration.

If the mapping specifies a connection parameter and after you create the

mapping

task, you edit the mapping to change the source object, you might need to edit the task. Check the specific connection in the

mapping

task to determine if you need to reset it and then validate the task again

On the

Sources

page, configure the following details as required:

Source parameter detail	Description
Connection	Select a connection. For a Visio template, the list of available connections depends on the connections associated with the runtime environment and the connection types allowed by the Visio template.
Object	Select a source object. If a list of objects does not appear, click Select . The Select Source Object dialog box displays up to 200 objects. If the object you want to use does not appear, enter a search string to reduce the number of objects that appear. To configure advanced properties for the source, 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 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. Object field names cannot start with a number.
Add Currently Processed File Name	Adds the source file name to each row. Data Integration adds the CurrentlyProcessedFileName field to the source at run time. Available for parameterized source objects with flat file connections.
Display Technical Field Names Instead of Labels	Displays technical names instead of business names. Not available for all connection types.
Display Source Fields in Alphabetical Order	Displays source fields in alphabetical order. By default, fields appear in the order returned by the source system.

For a parameterized source object, configure field metadata if required.

You can configure field metadata for sources 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 configure field metadata, click

Edit Types

. In the

Edit Field datatypes

dialog box, configure the following attributes and click

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.
Datatype	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.

If necessary, configure query options.

For Visio templates, configure lookup details if necessary.

This appears 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 appear, click

Select

For some connection types, you can click

Advanced

to configure advanced properties for the connection.

For some connection types, you can select

Display technical field names instead of labels

to display technical names instead of business names.

To display fields in alphabetical order, click

Display lookup fields in alphabetical order

If necessary, configure mapplet details.

This appears when a mapplet requires a connection, and the mapplet is configured to display on this page.

For some connection types, you can select