Skip to content
No results
We use cookies to ensure that we give you the best experience on our website.

# Collect data lineage and perform column impact analysis

Dlineage is a tool collects data lineage information from a group of SQL scripts and present it in a graphical format. It extracts information on data flows, revealing the path of data between database tables, views, individual columns.

This tool allows you to perform reliable impact analysis, and trace data to their origin.

Sample SQL:

    CREATE OR REPLACE VIEW products
    AS
    SELECT i.product_id
    ,      d.language_id
    ,      CASE WHEN d.language_id IS NOT NULL
                THEN d.translated_name
                ELSE TRANSLATE(i.product_name USING NCHAR_CS)
           END    AS product_name
    ,      i.category_id
    ,      CASE WHEN d.language_id IS NOT NULL
                THEN d.translated_description
                ELSE TRANSLATE(i.product_description USING NCHAR_CS)
           END    AS product_description
    ,      i.weight_class
    ,      i.warranty_period
    ,      i.supplier_id
    ,      i.product_status
    ,      i.list_price
    ,      i.min_price
    ,      i.catalog_url
    FROM   product_information  i
    ,      product_descriptions d
    WHERE  d.product_id  (+) = i.product_id
    AND    d.language_id (+) = sys_context('USERENV','LANG');

Generated image: