Table of Contents

Search

  1. Preface
  2. Using Metadata Manager
  3. Viewing Metadata
  4. Searching Metadata
  5. Working with Shortcuts and Folders
  6. Editing Metadata
  7. Working with Data Lineage
  8. Sharing Metadata
  9. Business Glossaries
  10. Using the URL API
  11. Appendix A: Configure the Web Browser
  12. Appendix B: Glossary

Metadata Manager User Guide

Metadata Manager User Guide

Relationships to PowerCenter Objects

Relationships to PowerCenter Objects

You can create a relationship between a business term and a PowerCenter object.
Some PowerCenter objects can be used in multiple contexts, used in a single context, or can refer to an original object.
The information that a data lineage diagram displays depends on the following PowerCenter object types that you can associate to a business term:
Reusable transformation or session
A reusable transformation or session can be used in multiple contexts.
When you run data lineage analysis on the business term, the data lineage diagram displays the PowerCenter object and all instances of the object. However, when you view the details of the business term, the
Related Catalog Objects
section displays only the reusable PowerCenter object.
When you run data lineage analysis on any instance of the PowerCenter object, the data lineage diagram displays the associated business term. However, when you view the details of an instance of the PowerCenter object, the
Related Business Terms
section does not display the business term.
If the reusable object is not used in another PowerCenter object, the data lineage diagram does not display the relationship between the business term and the reusable object.
Instance of a transformation or session
An instance of a transformation or session is used in a single context.
When you run data lineage analysis on the business term, the data lineage diagram displays the PowerCenter object instance within the context where the instance is used. For example, you relate a business term to a Lookup transformation instance. The data lineage diagram of the business term shows the Lookup transformation instance within its corresponding mapping and session context.
Shortcut
A shortcut refers to an original object.
When you run data lineage analysis on the business term, the diagram displays the instances of the original object and all instances of the shortcuts to the original object. However, when you view the details of the business term, the Related Catalog Objects section displays only the shortcut.
When you reload the PowerCenter resource, Metadata Manager creates or deletes associations based on changes made to the source. For example, you create a relationship between a business term and a reusable PowerCenter transformation that has one instance in a mapping. In the PowerCenter source, you add another instance of the transformation to a mapping. When you reload the PowerCenter resource, Metadata Manager associates the additional instance of the transformation to the business term.

0 COMMENTS

We’d like to hear from you!