In this case, you will need to monitor all data replication and distribution processes closely. It is a potentially disastrous situation to have the parent out of synch with the child subset data mart. Index builds After the tables are loaded and replicated, the indexes must be updated or re-built. Alarms must be set if these fail, as the resulting loss of system performance will render it useless. Core infrastructure factors must also be monitored, such as disk fragmentation.
Disk fragmentation can have very detrimental effects on system response time.
As the data mart system tables are appended with incremental delta data they will begin to fragment. It is important to monitor this situation and re-conform the data files when necessary. As incremental data is added to the data structures in the data mart, attention must be paid to load balancing between these logical and physical boundaries. Index fragmentation Just as the tables are fragmented, the indexes also are spread across multiple logical and physical boundaries. The system must be monitored in order to determine when it is appropriate to refresh or rebuild the entire index structure.