System

You can run forward and reverse lineage analysis to trace metadata at the system level. Forward lineage analysis generates lineage with the system as source. And, reverse lineage analysis generates lineage with the system as target. The Dual-Combined View lineage analysis generates a lineage, which includes both forward and reverse lineage.

This topic walks you through the following:

Viewing Lineage

To run lineage at the system level, follow these steps:

  1. Go to Application Menu > Data Catalog > Mapping Manager.
  2. In the Workspace Mappings pane, click the required mapping.
  3. The Mapping Specification grid appears.

  4. Select a row.
  5. Right-click a system and hover over Lineage Analyzer.
  6. The options available for Lineage Analyzer appear.

  7. Hover over any one of the following:
    • Forward: Use this option to view forward lineage.
    • Reverse: Use this option to view reverse lineage.
    • Dual - Combined View: Use this option to view combined forward and reverse lineage.

    For example, when you hover over Forward, All Projects and By Project appear as options.

  8. Use the following options:
    All Projects
    Use this option to include all the projects in lineage analysis.
    By Project
    Use this option to select projects for lineage analysis.
    By default, all projects are selected. Clear the check boxes for the projects that are not required. Then, click .
    The system's forward lineage is generated based on the options you selected. Similarly, you can generate reverse, and dual lineage for a system. By default, the lineage appears in Graphical View.
  9. You can click Graphical View or Grid View to switch between them:
    • Graphical View: The graphical view displays the lineage of a system in a graphical format. Selecting a system on the graphical view displays its properties in the Node Properties pane and Legends.
      On the Node Properties pane, click to view the selected object's properties in a new window.

    • Grid View: The grid view displays the lineage of a system in a tabular format. You can view the source and target system associated with the selected system.

  10. Use the following options to work on the lineage in graphical view:
    Options ()
    Use this option to view lineage types, business properties and customizations options. For more information on lineage options, refer to the Working on Lineage section.
    Export to Image ()
    Use this option to download the lineage view as an image, in the .jpg format. Ensure that you expand the required nodes in a linage before downloading the lineage image.
    Export to PDF ()
    Use this option to download the lineage report in the .pdf format. Ensure that you expand the required nodes in a linage before downloading the lineage report as PDF.
    Export to Excel ()
    Use this option to download the lineage report in the .xlsx format. Ensure that you expand the required nodes in a linage before downloading the report.
  11. On the lineage, expand a system node, and select an environment to view its lineage path. The environment is highlighted in orange color, its forward lineage path appears in red, and its reverse lineage path appears in blue. Systems that are not part of a lineage path disappear.

    Right-click a path around the selected object to highlight its path of the source or target in the lineage.

Working on Lineage

Lineage of a system shows how metadata moves through systems. It provides a summary of environments used as source and target in a graphical view. Also, it gives you information about the systems and environments involved in the lineage.

Use the following options to work on lineage:

Forward Lineage

Use this option to view forward lineage of the system.

Reverse Lineage

Use this option to view reverse lineage of the system.

Dual Lineage

Use this option to view dual lineage, which includes both forward and reverse lineage of the system.

Sensitivity Indicator

Use this option to view sensitivity of the environments in the lineage. You can expand a system node to view sensitive environments. The sensitive system and environments are indicated using .

Logical Name

Use this option to view expanded logical names of the tables and columns in an environment in the lineage. You can expand a system node to view environments and tables.

For example, the following image displays the table's logical name in the lineage.

Expanded Logical Name

Use this option to view expanded logical names of the tables and columns in an environment in the lineage. You can expand a system node to view environments, tables, and columns. For more information, on configuring extended properties of a system, refer to the System topic

For example, the following image displays the table's expanded logical name in the lineage.

DQ Tool Score

Use this option to view the data quality score of the environments, tables, and columns in the lineage. You can expand a system node to view data quality scores for environments, tables, and columns.

For example, the following image displays the data quality score in the lineage.

Auto Layout

Use this option to rearrange the layout of the lineage automatically.
For example, the following image displays the rearranged object layout with respect to the previous screenshot.

Overview Lineage

Use this option to view the lineage excluding systems and environments that do not exist in the Metadata Manager. When this option is switched off, the views include systems and environments, that do not exist in the Metadata Manager.

For example, the following image displays lineage excluding assets that do not exist in Metadata Manager.

Overview Pane

Use this option to remove the lineage overview pane from the graphical view.