If a PowerCenter source repository uses parameter files in sessions and workflows, you can configure Metadata Manager to read the parameter files when you load the PowerCenter resource. PowerCenter parameters can represent flat file sources, flat file lookups, flat file targets, relational connections, or objects in SQL overrides. Metadata Manager can read the parameter files to extract metadata for the flat file sources, flat file lookups, flat file targets, relational connections, and objects in SQL overrides.
Assign parameter files to PowerCenter workflows to perform data lineage analysis between the PowerCenter repository and the metadata in the flat file sources, flat file lookups, flat file targets, relational connections, or objects in SQL overrides. Metadata Manager uses the information in the parameter files to display data lineage.
To assign the parameter files, you upload the parameter files to the node running the Metadata Manager application. After you upload the parameter files, you assign the parameter files to individual workflows or to all workflows in the PowerCenter repository. You can also direct Metadata Manager to automatically assign the parameter files to the appropriate workflows in the PowerCenter repository.
After you upload modified parameter files or change parameter file assignments, you must reload the PowerCenter resource. Metadata Manager can then use the updated parameter file assignments to display data lineage.