Metadata Manager User Guide

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

Back Next

Viewing Data Lineage in Microsoft Excel

When you export a data lineage diagram to Microsoft Excel, the exported diagram includes all metadata objects and connections.

The following table describes the worksheets in the Microsoft Excel file:

Worksheet Name	Description
Lineage Information	General information about the data lineage diagram.
Structure-Level Information	Properties for each structure in the data lineage diagram, organized by resource name. A structure is an object in the metadata catalog or business glossary that contains fields. For example, a structure can be a PowerCenter source definition instance or an Oracle table.
Field-Level Information	Properties for fields in the diagram, organized by resource name. A field is a subset of a structure. For example, a field can be a PowerCenter transformation port or an Oracle table column.
Connections By Structure	List of each structure in the diagram. Includes the structures and fields to which each structure and its corresponding fields are connected in the diagram. Connections are organized by resource name and structure name.
All Connections	List of all connections between structures and fields in the diagram.

You can use the exported data lineage diagram to determine the impact of metadata changes on all metadata objects in a data lineage flow. For example, multiple reports in a business intelligence tool use a table in an Oracle database. A column is added to the table. You want to assess the impact of the column change on the metadata objects in the reports that reference the Oracle table. You can trace the effect of the metadata change by viewing all metadata objects that reference the Oracle table.

The Microsoft Excel file includes hyperlinks to information in other worksheets in the file. Use the hyperlinks to move between worksheets and get details about structure, field properties, and field connections.

Sharing Metadata

Lineage Information Worksheet

Structure-Level Information Worksheet

Field-Level Information Worksheet

Connections By Structure Worksheet

All Connections Worksheet

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal