Table of Contents

Search

  1. Preface
  2. Using Metadata Manager
  3. Configuring Metadata Manager
  4. Application Resources
  5. Business Glossary Resources
  6. Business Intelligence Resources
  7. Custom Resources
  8. Data Integration Resources
  9. Data Modeling Resources
  10. Database Management Resources
  11. Universal Resources
  12. Managing Resources
  13. Loading and Monitoring Resources
  14. Managing Permissions
  15. Resource Migration
  16. Repository Migration
  17. Appendix A: Metadata Manager Login
  18. Appendix B: Metadata Manager Properties Files
  19. Appendix C: Resource Configuration Files
  20. Appendix D: Glossary

Metadata Manager Administrator Guide

Metadata Manager Administrator Guide

PowerCenter Parameter Files

PowerCenter Parameter Files

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.

0 COMMENTS

We’d like to hear from you!