You can choose which resources to hide in the summary view. Hide a resource when the resource contains objects such as staging tables that do not affect overall data lineage. To hide a resource and its child objects in the summary view of data lineage diagrams, enable the
Hide in Summary Lineage
option.
You enable the
Hide in Summary Lineage
option for a resource when you create or edit the resource on the
Load
tab. The
Hide in Summary Lineage
option appears on the
Properties
page. The option is disabled by default. You can enable this option for any resource. When you enable this option, Metadata Manager hides the resource and its child objects in the summary view of all data lineage diagrams.
For example, you have a QlikView report in a universal resource that was generated through the following process:
Data for the report originates from a Greenplum table in a universal resource and an Oracle table.
A PowerCenter mapping transforms the data and loads it to a staging database.
A second PowerCenter mapping transforms the staging data and loads it to a table in a data mart.
You query the data mart to generate the QlikView report.
You want to view data lineage for the report, but you are not interested in the data transformation process that occurs through the PowerCenter mappings or the staging database. You edit the PowerCenter resources and the resource that contains the staging database and enable the
Hide in Summary Lineage
option. You then start data lineage analysis from the QlikView report.
The following image shows the data lineage in the summary view:
To see all of the resources in the data lineage diagram, switch to the detail view.
The following image shows the diagram in the detail view: