Your browser does not support JavaScript. This help page requires JavaScript to render correctly. Lineage and Impact Analysis Diagrams
Skip Headers
Previous
Previous
 
Next
Next

Lineage and Impact Analysis Diagrams

Lineage and Impact Analysis (LIA) diagrams show the relationships among objects managed by OWB. These relationships are constructed by mappings and structural relationships (for example, a primary key and foreign key relationship). The lineage diagram for a particular object shows its source objects, and the impact diagram shows its targets.

Lineage and impact are mirror images of each other. If Object A is part of the lineage diagram of Object B, then Object B is part of the impact diagram of Object A. When you read a diagram from left to right, you are seeing impact. When you read it from right to left, you are seeing lineage.


Tip:

Managing and Exploring Objects in an LIA Diagram in Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide

For example, you might have a mapping that extracts data from a file and loads it into a table by way of an external table. This is the relationship:

flat_file > external_table > table

Lineage Analysis Diagram for ADDRESS_EXT_TABLE

Screen capture of a lineage analysis diagram
Description of "Lineage Analysis Diagram for ADDRESS_EXT_TABLE"

Impact Analysis Diagram for ADDRESS_EXT_TABLE

Screen capture of an impact analysis diagram
Description of "Impact Analysis Diagram for ADDRESS_EXT_TABLE"

Lineage and Impact Analysis Diagram

Screen capture of a lineage and impact analysis diagram.
Description of "Lineage and Impact Analysis Diagram"