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

Data Lineage Example

Data Lineage Example

You can use data lineage to analyze how data is transformed in PowerCenter and how the output data is used in Business Objects.
You can analyze the data flow at the table level to determine which relational and flat file PowerCenter sources populate data in a particular PowerCenter target. You can drill in to the table-level results to determine how PowerCenter transforms data at the port level. You can then analyze how and where PowerCenter target data is used in Business Objects reports.
PowerCenter and Business Objects do not physically store the data that gets transformed. Instead, the data resides in a database. For example, PowerCenter source definitions and target definitions can represent database tables. Data lineage includes analysis of the underlying databases.
The following figure shows an example data lineage diagram:
Data lineage shows the following connections: Microsoft SQL Server database -> PowerCenter repository -> Oracle database -> Business Objects repository.
To view links between custom resources and either packaged or universal resources in a data lineage diagram, create linking rules for the resources. Or, create a class-level relationship for the custom model class. After you create the class-level relationship, add the relationship between the metadata objects.


Updated August 29, 2018