Mappings

Back Next

Input parameter types

You can create different types of input parameters. The type of parameter indicates how and where you can use the parameter.

For example, when you create a connection parameter, you can use it as a source, target, or lookup connection. An expression parameter can represent an entire expression in the Expression transformation or the join condition in the Joiner transformation. In a transformation, only input parameters of the appropriate type display for selection.

You can create the following types of input parameters:

string: Represents a string value to be used as entered.; In the task, the string parameter displays as a text box in most instances. A Named Fields string parameter displays a list of fields from which you can select a field.; You can use string parameters in the following locations:
All transformations: Field rule bulk rename by pattern
All transformations: Field name for the Named Fields field selection criteria
Filter condition value in the Filter transformation
Joiner condition value in the Joiner transformation
User-entered query in the SQL transformation
Advanced transaction control condition in the Transaction Control transformation
connection: Represents a connection. You can specify the connection type for the parameter or allow any connection type.; In the task, the connection parameter displays a list of connections.; You can use connection parameters in the following locations:
Source connection
Lookup connection
Mapplet connection
Database connection in the SQL transformation
Target connection; If you want to use a connection parameter with a data object or query, configure the mapping with an actual connection. After you configure the mapping logic, replace the connection with the connection parameter. If you need to edit the object or query, in the mapping, reselect the connection. After you save your changes, replace the connection with the connection parameter again.
expression: Represents an expression.; In the task, displays the Field Expression dialog box to configure an expression.; You can use expression parameters in the following locations:
Full expression in the Expression transformation
Full join condition in the Joiner transformation
Full lookup condition in the Lookup transformation
Transaction control condition in the Transaction Control transformation
data object: Represents a data object, such as a source table or source file.; In the task, appears as a list of available objects from the selected connection.; You can use data object parameters in the following locations:
Source object
Lookup object
Target object
field: Represents a field.; In the task, displays as a list of available fields from the selected object.; You can use field parameters in the following locations:
Field in a filter condition in the Filter transformation
Field in a join condition in the Joiner transformation
Field in a lookup condition in the Lookup transformation
Advanced transaction control condition in the Transaction Control transformation
field mapping: Represents field mappings for the task. You can create a full or partial field mapping.; Use a full field mapping parameter to configure all field mappings in the task. In the task, a full field mapping parameter displays all fields for configuration.; Use a partial field mapping to configure field mappings in the mapping and in the task.; You can use a partial field mapping parameter as follows:
Preserve links configured in the mapping. Link fields in the mapping that must be used in the task.
In the task, the parameter displays the unmapped fields.

Allow changes to the links configured in the mapping. Link fields in the mapping that can be changed in the task.
In the task, the parameter displays all fields and the links configured in the mapping. You can create links and change existing links.; You can use field mapping parameters in the following locations:
Field mapping in the Mapplet transformation
Field mapping in the Target transformation
mask rule: Represents a masking technique.; In the task, the mask rule parameter displays a list of masking techniques. You select and configure a masking technique in each incoming field.