{"id":1719,"date":"2015-09-21T21:09:55","date_gmt":"2015-09-22T02:09:55","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?page_id=1719"},"modified":"2015-09-21T21:29:34","modified_gmt":"2015-09-22T02:29:34","slug":"collect-data-lineage-and-perform-column-impact-analysis","status":"publish","type":"page","link":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/collect-data-lineage-and-perform-column-impact-analysis\/","title":{"rendered":"Collect data lineage and perform column impact analysis"},"content":{"rendered":"

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.<\/p>\n

This tool allows you to perform reliable impact analysis, and trace data to their origin.<\/p>\n

Sample SQL:<\/p>\n

    \r\nCREATE OR REPLACE VIEW products\r\nAS\r\nSELECT i.product_id\r\n,      d.language_id\r\n,      CASE WHEN d.language_id IS NOT NULL\r\n            THEN d.translated_name\r\n            ELSE TRANSLATE(i.product_name USING NCHAR_CS)\r\n       END    AS product_name\r\n,      i.category_id\r\n,      CASE WHEN d.language_id IS NOT NULL\r\n            THEN d.translated_description\r\n            ELSE TRANSLATE(i.product_description USING NCHAR_CS)\r\n       END    AS product_description\r\n,      i.weight_class\r\n,      i.warranty_period\r\n,      i.supplier_id\r\n,      i.product_status\r\n,      i.list_price\r\n,      i.min_price\r\n,      i.catalog_url\r\nFROM   product_information  i\r\n,      product_descriptions d\r\nWHERE  d.product_id  (+) = i.product_id\r\nAND    d.language_id (+) = sys_context('USERENV','LANG');\r\n<\/pre>\nGenerated image:<\/p>\n<\/p>\n","protected":false},"excerpt":{"rendered":"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 ,\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":235,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"gsp_feature_page_tt.php","meta":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"\nHelp you to make better use of General SQL Parser<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n