les09资料参考 学习.pptVIP

Refreshing the Warehouse Data Objectives After completing this lesson, you should be able to do the following: Describe methods for capturing changed data Explain techniques for applying the changes Describe refresh mechanisms supported in Oracle Database 11g Describe techniques for purging and archiving data and outline the techniques supported by Oracle Outline final tasks, such as publishing the data and automating processes Lesson Agenda Capturing the changed data and the available refresh mechanisms in the Oracle database Applying the changes Performing the final tasks Developing a Refresh Strategy for Capturing Changed Data Consider load window. Identify data volumes. Identify cycle. Know the technical infrastructure. Plan a staging area. Determine how to detect changes. User Requirements and Assistance Users define the refresh cycle. IT balances requirements against technical issues. Document all tasks and processes. Employ user skills. Load Window Requirements Time available for the entire extraction, transformation, and loading (ETL) process Plan Test Prove Monitor Planning the Load Window Plan and build processes according to a strategy. Consider volumes of data. Identify technical infrastructure. Ensure currency of data. Consider user access requirements first. High availability requirements may mean a small load window. Scheduling the Load Window Scheduling the Load Window Scheduling the Load Window Capturing Changed Data for Refresh Capture new fact data. Capture changed dimension data. Determine method of capture in each case. Methods: Wholesale data replacement Comparison of database instances Time-stamping Database triggers Database log Choosing a Method for Change Data Capture Consider each method on merit. Consider a hybrid approach if one approach is not suitable. Consider current technical, operational, and application issues. Wholesale Data Replacement It is expensive. It is useful for data marts with less data. Limited historical data anal