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