Lineage Impact Analysis
      Back to home
      1. Knowledge Base
      2. Self Service
      3. 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.