After a job runs in Metadata Command Center, view the results in Data Governance and Catalog. You can view details about source system contents in a hierarchical structure and trace data lineage.
1Log in to Informatica Intelligent Cloud Services.
The My Services page appears.
2Click Data Governance and Catalog.
The following image shows the Data Governance and Catalog box on the My Services page:
3On the Data Governance and Catalog home page, click the number in the Technical Assets panel.
The Technical Assets page opens.
4Select Catalog Source in the Filter list.
The list of catalog sources opens.
5Search for the catalog source from which you extracted metadata, and click the name.
The Overview tab of the asset opens.
The following image shows a sample asset page:
6View the asset from different perspectives by clicking on the tabs.
For more information about working with assets, see Working with Assets in Data Governance and Catalog help.
View data lineage
Data lineage views are available for technical assets in the catalog source. You can view lineage at the source, target, data set, or data element level.
Data lineage is a visual representation of the flow of data across the systems in your organization. Lineage depicts how the data flows from the system of its origin to the system of its destination.
View source lineage
The lineage diagram at the source or target level shows how data assets refer to and use sources.
To view data lineage at the source or target level, search for and open a technical asset, and then click the Lineage tab.
The following image shows how the TEST_TABLE3 target table of the IBM Db2 for LUW source system gets data from the TEST_TABLE2 source table of the IBM Db2 for LUW source system using the DB2_ConnAware.DB2_CONNAWARE 001 mapping instance of the Oracle Data Integrator source system after connection assignment:
View lineage at data set level and data element level
The lineage at the data set level and the data element level shows how other technical assets such as files or tables contribute to the selected asset.
Data sets are technical assets that contain sets of data. Data elements are objects downstream of a data set, and are accessible when you expand a data set to the data element level.
View lineage at the data set level
The data set level displays individual sets of data in the data flow.
To view lineage at the data set level, open a technical asset, click the Lineage tab, and then verify that the level is set to Data Set Level.
The following image shows data set level lineage where the TEST_TABLE3 target reference data set gets data from the TEST_TABLE2 source reference data set before connection assignment:
The following image shows data set level lineage where the TEST_TABLE3 target table gets data from the TEST_TABLE2 source table after connection assignment:
After connection assignment, the referenced object icons change to specific object icons.
View lineage at the data element level
The data element level displays details of the data set level. At the data element level, you can see the input sources for expressions or commands and calculations or transformations on the data.
To view data lineage at the data element level, open a technical asset, click the Lineage tab, and then verify that the level is set to Data Element Level.
The following image shows data element level lineage where the COL1 reference data element of the TEST_TABLE3 reference data set gets data from the COL1 reference data element of the TEST_TABLE2 reference data set using the COL1 calculation before connection assignment:
The following image shows data element level lineage where the COL1 column of the TEST_TABLE3 table gets data from the COL1 column of the TEST_TABLE2 table using the COL1 calculation after connection assignment:
After connection assignment, the referenced object icons change to specific object icons.
