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. Configure the Web Browser
  12. Glossary

Metadata Manager User Guide

Metadata Manager User Guide

PowerCenter Mappings in the Summary View

PowerCenter Mappings in the Summary View

By default, when you view a PowerCenter mapping in a data lineage diagram, Metadata Manager hides transformation logic within the mapping. Metadata Manager displays the mapping inputs and outputs but hides the transformation instances that change the data.
Mapping inputs are the endpoints through which data flows into a mapping. Mapping outputs are the endpoints through which data flows out of a mapping. Mapping inputs include source qualifier instances, lookup procedure instances, stored procedure instances, and mapplet instances that provide source data for the mapping. Mapping outputs are the target definition instances.
If you view a mapping that includes a mapplet instance, Metadata Manager hides the mapplet instance unless the mapplet provides source data for the mapping. Mapplets that provide source data for a mapping are called source mapplets.
In the summary view, Metadata Manager displays the inputs and outputs for source mapplets but hides the transformation instances that change the data. Inputs for source mapplets include source qualifier instances, lookup instances, and stored procedure instances. Outputs for source mapplets are the Output transformation instances.
For example, a PowerCenter mapping includes two source definition instances, two Source Qualifier transformation instances, a mapplet instance that provides source data for the mapping, a Joiner transformation instance, and two target definition instances.
The following image shows the mapping in the summary view:
The summary view of the mapping displays the Source Qualifier transformation instances, the mapplet instance, and the target definition instances.
To see all of the transformation instances within the mapping, switch to the detail view.
The following image shows the same mapping in the detail view:
The detail view of the mapping also displays the source definition instances and the Joiner transformation instance.

0 COMMENTS

We’d like to hear from you!