Table of Contents

Search

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

Mappings

Mappings

Input parameters

Input parameters

An input parameter is a placeholder for a value or values in a mapping. You define the value of the parameter when you configure the
mapping
task.
You can create an input parameter for logical aspects of a data flow. For example, you might use a parameter in a filter condition and a parameter for the target object. Then, you can create multiple tasks based on the mapping and write different sets of data to different targets. You could also use an input parameter for the target connection to write target data to different Salesforce accounts.
The following table describes the input parameters that you can create in each transformation:
Transformation
Input parameter use in mappings and tasks
Source
You can use an input parameter for the following parts of the Source transformation:
  • Source connection. You can configure the connection type for the parameter or allow any connection type. In the task, you select the connection to use.
  • Source object. In the task, you select the source object to use. For relational and Salesforce connections, you can specify a custom query for a source object.
  • Filter. In the task, you configure the filter expression to use. To use a filter for a parameterized source, you must use a parameter for the filter.
  • Sort. In the task, you select the fields and type of sorting to use. To sort data for a parameterized source, you must use a parameter for the sort options.
Target
You can use an input parameter for the following parts of the Target transformation:
  • Target connection. You can configure the connection type for the parameter or allow any connection type. In the task, you select the connection to use.
  • Target object. In the task, you select the target object to use.
  • Completely parameterized field mapping. In the task, you configure the entire field mapping for the task.
  • Partially parameterized field mapping. Based on how you configure the parameter, you can use the partial field mapping parameter as follows:
    • Configure links in the mapping and display unmapped fields in the task.
    • Configure links in the mapping and display all fields in the task. Allows you to edit links configured in the mapping.
All transformations with incoming fields
You can use an input parameter for the following parts of the
Incoming Fields
tab of any transformation:
  • Field rule: Named field. You can use a parameter when you use the Named Fields field selection criteria for a field rule. In the task, you select the field to use in the field rule.
  • Renaming fields: Pattern. You can use a parameter to rename fields in bulk with the pattern option. In the task, you enter the regular expression to use.
Aggregator
You can use an input parameter for the following parts of the Aggregator transformation:
  • Group by: Field name. In the task, you select the incoming field to use.
  • Aggregate expression: Additional aggregate fields. In the task, you specify the fields to use.
  • Aggregate expression: Expression for aggregate field. In the task, you specify the expression to use for each aggregate field.
Data Masking
You can use an input parameter for masking techniques in the Data Masking transformation.
In the task, you select and configure the masking techniques.
Expression
You can use an input parameter for an expression in the Expression transformation.
In the task, you create the entire expression.
Filter
You can use an input parameter for the following parts of the Filter transformation:
  • Completely parameterized filter condition. In the task, you enter the incoming field and value, or you enter an advanced data filter.
  • Simple or advanced filter condition: Field name. In the task, you select the incoming field to use.
  • Simple or advanced filter condition: Value. In the task, you select the value to use.
Joiner
You can use an input parameter for the following parts of the Joiner transformation:
  • Join condition. In the task, you define the entire join condition.
  • Join condition: Master field. In the task, you select the field in the master source to use.
  • Join condition: Detail field. In the task, you select the field in the detail source to use.
Lookup
You can use an input parameter for the following parts of the Lookup transformation:
  • Lookup connection. You can configure the connection type for the parameter or allow any connection type. In the task, you select the connection to use.
  • Lookup object. In the task, you select the lookup object to use.
  • Lookup condition: Lookup field. In the task, you select the field in the lookup object to use.
  • Lookup condition: Incoming field. In the task, you select the field in the data flow to use.
Mapplet
You can use an input parameter for the following parts of the Mapplet transformation:
  • Connection. If the mapplet uses connections, you can configure the connection type for the parameter or allow any connection type. In the task, you select the connection to use.
  • Completely parameterized field mapping. In the task, you configure the entire field mapping for the task.
  • Partially parameterized field mapping. Based on how you configure the parameter, you can use the partial field mapping parameter as follows:
    • Configure links in the mapping that you want to enforce, and display unmapped fields in the task.
    • Configure links in the mapping, and allow all fields and links to appear in the task for configuration.
You can configure input parameters separately for each input group.
Rank
You can use an input parameter for the number of rows to include in each rank group.
In the task, you enter the number of rows.
Router
You can use an input parameter for the following parts of the Router transformation:
  • Completely parameterized group filter condition. In the task, you enter the expression for the group filter condition.
  • Simple or advanced group filter condition: Field name. In the task, you select the incoming field to use.
  • Simple or advanced group filter condition: Value. In the task, you select the value to use.
Sorter
You can use an input parameter for the following parts of the Sorter transformation:
  • Sort condition: Sort field. In the task, you select the field to sort.
  • Sort condition: Sort Order. In the task, you select either ascending or descending sort order.
SQL
You can use an input parameter for the following parts of the SQL transformation:
  • Connection: In the Mapping Designer, select the stored procedure or function before you parameterize the connection. Use the
    Oracle or SQL Server
    connection type. In the task, you select the connection to use.
  • User-entered query: You can use string parameters to define the query. In the task, you enter the query.
Structure Parser
You can use an input parameter for the following parts of the Structure Parser transformation:
  • Completely parameterized field mapping. In the task, you configure the entire field mapping for the task.
  • Partially parameterized field mapping. Based on how you configure the parameter, you can use the partial field mapping parameter as follows:
    • Configure links in the mapping that you want to enforce, and display unmapped fields in the task.
    • Configure links in the mapping, and allow all fields and links to appear in the task for configuration.
Transaction Control
You can use an input parameter for the following parts of the Transaction Control transformation:
  • Transaction Control condition: In the task, you specify the expression to use as the transaction control condition.
  • Advanced transaction control condition: Expression. In the task, you specify the string or field to use in the expression.
Union
You can use an input parameter for the following parts of the Union transformation:
  • Completely parameterized field mapping. In the task, you configure the entire field mapping for the task.
  • Partially parameterized field mapping. Based on how you configure the parameter, you can use the partial field mapping parameter as follows:
    • Configure links in the mapping that you want to enforce, and display unmapped fields in the task.
    • Configure links in the mapping, and allow all fields and links to appear in the task for configuration.
You can configure input parameters separately for each input group.