Lineage Impact Analysis

Impacted objects list

Users can apply various filter options available in the table columns to understand the impact objects data.

This table provides the list of all impacted objects, for the affected objects specified in the entry. It has the following columns:

                    Field                                             Description

Affected Id

Id of the affected object

Impact type

·  Transformation: If lineage is direct between table to table or table to file without any intermediate query.

·  View: If a view object is present.

·  Function: If an intermediate function is present.

·  Procedure: If an intermediate procedure is present.

Source Type

Type of affected object (table/column/report)

Source Connection name

Name of the affected object connection Database.

Source System:

Name of the schema of affected object.

Source Object

Name of the affected object.

Source Field

Name of the affected object column.

Analysis type

Upstream / Downstream / Upstream with associations / Downstream with associations.

Project Status

Whether the impacted object has been added to a project. User can add it to a project, if needed.

Object type

Type of impacted object.

Connection Name

Name of the impacted object connection database.

System

Name of the schema of impacted object.

Object

Name of the impacted object.

Field

Name of the impacted object column.

Dataset Connection

Name of the intermediate dataset connection.

Dataset Name

Name of the intermediate dataset.

Job type

Type of the intermediate query object (procedure / view / function / SQL etc.)

Responsible code

The code of the intermediate query involved. Hover over the cell to view the full source code.

T/R Code

Transformation code, that is involved in the transformation between the affected object and impacted object.

T/R Type

Transformation type of the transformation code. The value displayed will based on the connector type.

Reviewed status

PENDING / REVIEWED. This is for users to confirm whether the impacted object identified has been verified independently.

Reviewed By

The user who reviewed the impacted object

Reviewed Date

The date on which the review was done

Status

ACTIVE / INACTIVE. Status of the impacted object. Typically temp lineage objects will be inactive.

Impact Level

The level of separation of the impacted object from the affected object.