Assigning Parameter Files to PowerCenter Workflows
Assigning Parameter Files to PowerCenter Workflows
After you upload parameter files, assign the files to PowerCenter workflows. You cannot assign parameter files to individual PowerCenter sources, targets, or lookups. You assign parameter files to the workflow that contains the sources, targets, and lookups.
On the
Load
tab, select the PowerCenter resource in the
Resources
panel.
In the
Properties
panel, click
Edit
.
The
Edit Resources
window appears.
Click the
Parameter Files
tab.
Perform one of the following tasks to assign parameter files:
To direct Metadata Manager to analyze the PowerCenter repository and assign the uploaded parameter files to each workflow that specifies the parameter file name, click
Auto-assign
.
To assign parameter files individually, select a parameter file in the
Parameter Files
list, select one or more folders or workflows in the
Workflow Folders
list, and click
Assign
.
To assign a parameter file to all workflows, select the parameter file and click
Assign to All
.
When you configure a PowerCenter workflow, if you use an absolute file name or the $PMFolderName and $PMWorkflowName workflow variables to specify the parameter file name, Metadata Manager uses this value to automatically assign the parameter file to the workflow. If you use any other workflow variable for configuring the parameter file name, you must assign the parameter file to the workflow manually.
To remove a parameter file from a workflow, click
Remove
for the parameter file in the bottom panel.
Click
OK
.
After you change parameter file assignments, you must reload the PowerCenter resource. Metadata Manager can then process the updated parameter file assignments to update links between resources to correctly display data lineage.
When you save a PowerCenter resource, the Metadata Manager service log lists workflows that have no assigned parameter file. To view the Metadata Manager service log, select