|
|  |  | |
There are three (3) important points in the loading of the operational data where the audit totals should be checked. Firstly, after the staging data is received from the operational system, the totals of the staging data should be compared to ensure valid loading of the staging schema. Secondly, before updating the data warehouse tables, the number of additions and deletions can be counted by a pre-validation (a non intrusive pass) of the update process. If there are any discrepancies, the data warehouse should not be updated at all and a critical error should be presented. Finally, after the data warehouse is updated, the active transactions should be counted and compared with the source data before the load process is considered to be successful.
BIAnalytix is a media data warehouse and business intelligence system from Decentrix which enforces strict and formal standards for data integrity and correctness. For example:
-
The MSTAR™ Star Schema has all relationships enforced, meaning that every spot has to have a valid advertiser, product category, etc
-
100's of Audit control totals are validated from the source systems to the final data warehouse ensuring that the data loaded into the warehouse is precisely balanced with the source operational systems
-
External Reconciliation processes compare report totals and details in both the source system and the Data Warehouse
-
Media Data Management (MDM) is supported within the Data Warehouse with Master Relationships, Mapping relationships, and Corporate Mapping
|
|
