System and method for automatically validating data stored in multiple locations

A method comprising:

• receiving a first request to validate a set of data stored in a first target table against a set of data stored in a first source table, each element of the set of data stored in the first target table corresponding to an element of the set of data stored in the first source table;
• in response to receiving the first request:
• loading the set of data stored in the first source table into a memory as a first set of loaded source data;
• loading the set of data stored in the first target table into the memory as a first set of loaded target data;
• comparing each element of the first set of loaded source data with a corresponding element of the first set of loaded target data to identify a set of disagreements, the set of disagreements comprising a first disagreement between a first element of the first set of loaded source data and a corresponding first element of the first set of loaded target data, wherein:
• the first element of the first set of loaded source data comprises a first ordered set of alphanumeric characters;
• the first element of the first set of loaded target data comprises a second ordered set of alphanumeric characters;
• and
• the first disagreement indicates that the first ordered set of alphanumeric characters is different from the second ordered set of alphanumeric characters;
• and
• in response to identifying the first disagreement, determining that the first element of the first set of loaded source data does not match the first element of the first set of loaded target data, wherein:
• the first element of the first set of loaded source data comprises a first value stored according to a first format;
• and
• the first element of the first set of loaded target data comprises a second value stored according to a second format, the first value different from the second value and the second format different from the first format, wherein determining that the first element of the first set of loaded source data does not match the first element of the first set of loaded target data comprises:
• determining that the first format is different from the second format;
• and
• in response to determining that the first format is different from the second format, performing at least one of:
• converting the first element of the first set of loaded source data from the first format to the second format;
• and
• converting the first element of the first set of loaded target data from the second format to the first format;
• and
• in response to determining that the first element of the first set of loaded source data does not match the first element of the first set of loaded target data:
• extracting an element of the first source table corresponding to the first element of the first set of loaded source data;
• transforming the element of the first source table from the first format to the second format;
• and
• loading the transformed element of the first source table into the first target table.

An apparatus comprising:

• a memory;
• and
• a hardware processor communicatively coupled to the memory, the hardware processor configured to:
• receive a first request to validate a set of data stored in a first target table against a set of data stored in a first source table, each element of the set of data stored in the first target table corresponding to an element of the set of data stored in the first source table;
• in response to receiving the first request:
• load the set of data stored in the first source table into the memory as a first set of loaded source data;
• load the set of data stored in the first target table into the memory as a first set of loaded target data;
• compare each element of the first set of loaded source data with a corresponding element of the first set of loaded target data to identify a set of disagreements, the set of disagreements comprising a first disagreement between a first element of the first set of loaded source data and a corresponding first element of the first set of loaded target data, wherein:
• the first element of the first set of loaded source data comprises a first ordered set of alphanumeric characters;
• the first element of the first set of loaded target data comprises a second ordered set of alphanumeric characters;
• and
• the first disagreement indicates that the first ordered set of alphanumeric characters is different from the second ordered set of alphanumeric characters;
• and
• in response to identifying the first disagreement, determine that the first element of the first set of loaded source data does not match the first element of the first set of loaded target data, wherein:
• the first element of the first set of loaded source data comprises a first value stored according to a first format;
• and
• the first element of the first set of loaded target data comprises a second value stored according to a second format, the first value different from the second value and the second format different from the first format, wherein determining that the first element of the first set of loaded source data does not match the first element of the first set of loaded target data comprises:
• determining that the first format is different from the second format;
• and
• in response to determining that the first format is different from the second format, performing at least one of:
• converting the first element of the first set of loaded source data from the first format to the second format;
• and
• converting the first element of the first set of loaded target data from the second format to the first format;
• and
• in response to determining that the first element of the first set of loaded source data does not match the first element of the first set of loaded target data:
• extract an element of the first source table corresponding to the first element of the first set of loaded source data;
• transform the element of the first source table from the first format to the second format;
• and
• load the transformed element of the first source table into the first target table.