Table of Contents


  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Appendix A: Datatype Reference
  17. Appendix B: Configure the Web Browser

Viewing Data Lineage Overview

Viewing Data Lineage Overview

You can use Metadata Manager to trace the flow of data in PowerCenter from the sources to targets. With the Metadata Manager data lineage, you can analyze where data originates, how the data is transformed and what objects transform it, and where the data ends. You can analyze the data flow within a single PowerCenter repository or across multiple PowerCenter repositories.
You can display the data lineage for PowerCenter objects in the Designer. When you display data lineage for a PowerCenter object, the Designer connects to the Metadata Manager application and extracts the data lineage information from the Metadata Manager warehouse. The data lineage diagram appears in a browser window.
Data lineage analysis on a PowerCenter repository displays one or more of the following PowerCenter objects:
  • Repositories.
    You can load objects from multiple PowerCenter repositories into Metadata Manager. In the data lineage, Metadata Manager displays the repository for each metadata object.
  • Data structures.
    Data lineage on a PowerCenter object includes the source definition, target definition, and transformation data structures.
  • Fields.
    Fields are objects within data structures that store the metadata. Data lineage on a PowerCenter object includes the source, target, and transformation ports.

Updated March 29, 2021