Abstract: A dimension table is populated with data records extracted from at least one source system with each data record being associated with identifying hash values and attribute hash values. Once the dimension table is established, a set of hash values is computed for an incoming set of data records. The incoming set of hash values may include at least one identifying hash value and at least one attribute hash value for each data record contained in the incoming set of data records. The method then searches the established dimension table for records having an identifying hash value identical with the identifying hash value of the incoming set of data records. Once a match is found, the method compares the attribute hash values of the records having the identical identifying hash values. If the attribute hash values are different, the method updates the dimension table with the incoming data record.

Abstract: A computer-implemented method for updating multiple data records in a database in a single transaction. The method includes searching a data model associated with the data records in the database for fields related to an objective. Once complete, a user will enter new objective values associated with the objective. The processor then performs a business rule validation of the fields found during the searching step with the new objective values entered. The report is then displayed to a user on a display. The user reviews the report and may approve the new objective values. If approved, the finalized objective values are applied to the database.