Data lineage
Data lineage shows the data flow from the data destination (output component), through various components and stages, to the data source (input component). The data lineage results trace the life cycle of the data flow between different components, including the operations that are performed upon the data.
The example below shows the data lineage made on a database connection item stored under the Metadata node in the Repository tree view.
To launch a data lineage on a metadata item, complete the following:
Procedure
-
Right-click the centralized table schema of which you want to
analyze the life cycle of the data flow, employees in this example.
The Impact Analysis view displays the Jobs that use the selected table schema. The names of the selected database connection and table schema are displayed in the corresponding fields.
-
Right-click a listed Job and select Open Job from the contextual menu.
The Job opens in the design workspace.
The data lineage results trace backward the components and transformations the data in the output column Name passes through before being written in this column.