les11资料参考 学习.pptVIP

Leaving a Metadata Trail Objectives After completing this lesson, you should be able to do the following: Define warehouse metadata, its types, and its role in a warehouse environment Examine each type of warehouse metadata Develop a metadata strategy Outline the Common Warehouse Metamodel (CWM) Describe Oracle Warehouse Builder’s compliance with Object Management Group’s Common Warehouse Metamodel (OMG-CWM) Defining Warehouse Metadata Descriptive data about warehouse data and processes Vital component of data warehouse Used by everyone The key to understanding warehouse information Metadata Users Types of Metadata End-user metadata: Key to a good warehouse Navigation aid Information provider Context Extraction, transformation, and loading (ETL) metadata: Structure mapping Source and target information Transformations Operational metadata: Load, management, scheduling processes Performance Examining Metadata: ETL Metadata Business rules Source tables, fields, and key values Ownership Field conversions Encoding and reference table Name changes Key value changes Default values Logic to handle multiple sources Algorithms Time stamp Extraction Metadata Space and storage requirements Source location information Diverse source data Access information Security Contacts Program names Frequency details Failure procedures Validity checking information Transformation Metadata Duplication routines Exception handling Key restructuring Grain conversions Program names Frequency Summarization Loading Metadata Method of transfer Frequency Validation procedures Failure procedures Deployment rules Contact information Examining Metadata: End-User Metadata Location of fact and dimensions Availability Description of contents and algorithms used for derived and summary data Data ownership details End-User Metadata: Context Historic Context of Data Supports change history Maintains the context of information Types of Context Simple: Data structures Naming conventions Metrics Complex: Pro