les08资料参考 学习.pptVIP

The ETL Process: Loading Data Objectives After completing this lesson, you should be able to do the following: Explain key concepts in loading warehouse data Outline how to build the loading process for the initial load Identify loading techniques Describe the loading techniques provided by Oracle Identify the tasks that take place after data is loaded Explain the issues involved in designing the transportation, loading, and scheduling processes Lesson Agenda Explain key concepts in loading warehouse data Outline how to build the loading process for the initial load Identify loading techniques Describe the loading techniques provided by Oracle Identify the tasks that take place after data is loaded Explain the issues involved in designing the transportation, loading, and scheduling processes Loading Data into the Warehouse Loading moves the data into the warehouse. Loading can be time consuming: Consider the load window. Schedule and automate the loading. Initial load moves large volumes of data. Subsequent refresh moves smaller volumes of data. Transportation in a Data Warehouse Three basic choices in transportation: Transportation using flat files Transportation through distributed operations Transportation using transportable tablespaces Transportable Tablespaces Are the fastest way for moving data between two Oracle databases Bypass the unload and reload steps Provide a mechanism for transporting data along with metadata Are useful for moving data from the: Staging database to a data warehouse Data warehouse to data marts Initial Load and Refresh Initial load: Is a single event that populates the database with historical data Involves large volumes of data Employs distinct ETL tasks Involves large amounts of processing after load Refresh: Performed according to a business cycle Less data to load than first-time load Less-complex ETL tasks Smaller amounts of postload processing Data Refresh Models: Extract Processing Environment After each time interval, bu