Detecting reference data tables in extract-transform-load processes

A computer program product for identifying reference data tables in an extract-transform-load data integration process, the computer program product comprising:

• a computer-readable storage medium having computer-readable program code embodied therewith, the computer-readable program code comprising:
• computer-readable program code configured to identify at least a first reference data operator in the process, wherein the first reference data operator references one or more tables;
• and
• computer-readable program code configured to evaluate at least a first table referenced by the reference data operator to determine whether the first table is a reference data table by assigning a score to the first table, wherein the score is indicative of the likelihood that the first table is a reference data table, wherein a reference data table contains a set of values that describes other data.

A system, comprising:

• one or more computer processors;
• and
• a memory containing a program, which when executed by the one or more computer processors is configured to perform an operation for detecting reference data tables in an extract-transform-load data integration process, the operation comprising:
• identifying at least a first reference data operator in the process, wherein the first reference data operator references one or more tables;
• and
• evaluating at least a first table referenced by the reference data operator to determine whether the first table is a reference data table by assigning a score to the first table, wherein the score is indicative of the likelihood that the first table is a reference data table, wherein a reference data table contains a set of values that describes other data.