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

Parameter Set Example

Parameter Set Example

If you assign a parameter set to a mapping, Metadata Manager displays the mapping in the metadata catalog and displays data lineage for the mapping based on the parameter values.
For example, an application contains the following mapping that reads data from an Oracle table, filters the data, and writes data to a flat file:
The mapping contains a Read transformation to read from a relational table, a Filter transformation to filter the data, and a Write transformation to write the filtered data to a flat file.
To change the source database between mapping runs, the mapping designer creates a connection parameter for the source connection and assigns it the default value Ora_DEV. The mapping designer creates a parameter set, PRODUCTION, and sets the source connection to Ora_PROD.
In Metadata Manager, you want to view the mapping and display lineage links with the values defined in the PRODUCTION parameter set. Assign the PRODUCTION parameter set to the mapping when you create the resource.
When you load the resource, Metadata Manager extracts the mapping using the parameter values defined in the parameter set. Therefore, when you view the resource on the Load tab, the Connection Assignment tab shows the connection as Ora_PROD. If you run data lineage on the mapping and select the relational source, Metadata Manager displays the connection name as Ora_PROD. Metadata Manager creates lineage links based on the Ora_PROD connection.

0 COMMENTS

We’d like to hear from you!