CODE LINEAGE TOOL

A code lineage tool includes a scanner, a parser, and an integrator. The scanner identifies elements in ETL code. The parser determines that a first element is affected by a second element and adds the first element to a parse tree and the second element to the parse tree as a sub-node of the first element. The parser determines that the second element is affected by a third element and adds the third element to the parse tree as a sub-node of the second element. The parser determines that a fourth element does not affect the first element and prevents the fourth element from being added to the parse tree or removes the fourth element from the parse tree. The integrator determines that a change to the third element will change the value of the first element and generates a lineage for the first element.