System and method for warehousing and retrieving data

Abstract

A system and method for preparing and integrating operational data received from nodes on a network prior to loading the data onto a data warehouse. Operational data received from nodes on a network is transformed to produce an output file of integrated data records which are audited to ensure data contained in the records has not already been loaded to the data warehouse in a previous operation. Data previously loaded onto the data warehouse is compared with current operational data to be loaded to determine whether the status of any nodes in the network has changed. The audited integrated operational data and data indicating which nodes, if any, have changed status since the previous upload of data are provided with unique identification numbers and uploaded to the data warehouse. In a preferred embodiment, the data concerns transactions occurring on, and the status of, components in customer activated terminals or transactions occurring on home banking servers. Once uploaded to the data warehouse, data may be viewed graphically by an end user querying the data warehouse.