Table of Contents

Search

  1. Preface
  2. Workflows
  3. Workflow Variables
  4. Workflow Parameters
  5. Cluster Tasks
  6. Command Task
  7. Human Task
  8. Mapping Task
  9. Notification Task
  10. Gateways
  11. Workflow Recovery
  12. Workflow Administration

Developer Workflow Guide

Developer Workflow Guide

Override Mapping Parameters During a Workflow Run

Override Mapping Parameters During a Workflow Run

You can override user-defined mapping parameter values during a workflow run by assigning user-defined mapping parameters to workflow parameters or variables in the Mapping task
Input
tab.
You cannot assign system mapping parameters used in the mapping to workflow parameters. If the mapping has a user-defined mapping parameter assigned to a flat file directory field, cache file directory field, or temporary file directory field, then you can assign the user-defined mapping parameter to a workflow string parameter.
You might want to override user-defined mapping parameter values for the following reasons:
Use run-time data for the user-defined mapping parameter value.
Assign a user-defined mapping parameter to a workflow variable when you want to use workflow run-time data for the parameter value. For example, use a workflow string variable to override a mapping string parameter that defines a flat file name. Use an Exclusive gateway to evaluate a condition and then run Assignment task A or Assignment task B. Assignment task A sets the workflow variable to FlatFileA.txt. Assignment task B sets the workflow variable to FlatFileB.txt. In the Mapping task input, assign the workflow variable to the mapping string parameter. When the Mapping task runs the mapping, the mapping uses the value dynamically assigned to the workflow variable for the source file name.
Assign distinct values to a user-defined mapping parameter that is used multiple times in the workflow.
When you include multiple Mapping tasks that run the same mapping in a single workflow, assign a user-defined mapping parameter to a distinct workflow parameter for each Mapping task. Define a distinct value for each workflow parameter in a parameter file. When you run the workflow with the parameter file, the mapping run by each Mapping task uses the value of the assigned workflow parameter.
For example, a workflow includes two Mapping tasks that contain the same mapping that uses the user-defined mapping parameter SourceConnection. When the workflow runs, you want to use a different source connection for each mapping. You assign the mapping parameter SourceConnection to a distinct workflow connection parameter for each Mapping task. For MappingTask1, you assign SourceConnection to the workflow parameter WF_SourceConnection1. For MappingTask2, you assign SourceConnection to the workflow parameter WF_SourceConnection2. Assign a parameter set to Mapping task. In the parameter set, configure distinct values for the workflow parameters WF_SourceConnection1 and WF_SourceConnection2.

0 COMMENTS

We’d like to hear from you!