Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapping tutorial
  4. Parameters
  5. CLAIRE recommendations
  6. Data catalog discovery
  7. Visio templates

Mappings

Mappings

Input parameter types

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.

0 COMMENTS

We’d like to hear from you!