Metadata Manager User Guide

10.4.1
- 10.5.7
- 10.5.6
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.0

Back Next

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.

Working with Data Lineage

Relationships

Object Handling

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal