Cargando…
Oracle Warehouse Builder 11g Getting Started : Getting Started.
Extract, Transform, and Load data to build a dynamic, operational data warehouse.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing,
2009.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Oracle Warehouse Builder 11g: Getting Started; Oracle Warehouse Builder 11g: Getting Started; Credits; About the Author; About the Reviewers; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code for the book; Errata; Piracy; Questions; 1. An Introduction to Oracle Warehouse Builder; Introduction to data warehousing; Introduction to our fictional organization; What is a data warehouse?; Where does OWB fit in?; Installation of the database and OWB; Downloading the Oracle software.
- A word about hardware and operating systemsInstalling Oracle database software; Configuring the listener; Creating the database; Installing the OWB standalone software; OWB components and architecture; Configuring the repository and workspaces; Summary; 2. Defining and Importing Source Data Structures; Preliminary analysis; ACME Toys and Gizmos source data; The POS transactional source database; The web site order management database; An overview of Warehouse Builder Design Center; Importing/defining source metadata; Creating a project; Creating a module; Creating an Oracle Database module.
- Creating a SQL Server database moduleCreating a SQL Server database connection; Configure Oracle to connect to SQL Server; Creating a heterogeneous service configuration file; Editing the listener.ora file; Creating the Warehouse Builder ODBC module for SQL Server; Importing source metadata from a database; Defining source metadata manually with the Data Object Editor; Importing source metadata from files; Summary; 3. Designing the Target Structure; Data warehouse design; Dimensional design; Cube and dimensions; Implementation of a dimensional model in a database.
- Relational implementation (star schema)Multidimensional implementation (OLAP); Designing the ACME data warehouse; Identifying the dimensions; Designing the cube; Data warehouse design in OWB; Creating a target user and module; Create a target user; Create a target module; OWB design objects; Summary; 4. Creating the Target Structure in OWB; Creating dimensions in OWB; The Time dimension; Creating a Time dimension with the Time Dimension Wizard; The Product dimension; Product Attributes (attribute type); Product Levels; Product Hierarchy (highest to lowest).
- Creating the Product dimension with the New Dimension WizardThe Store dimension; Store Attributes (attribute type), data type and size, and (Identifier); Store Levels; Store Hierarchy (highest to lowest); Creating the Store dimension with the New Dimension Wizard; Creating a cube in OWB; Creating a cube with the wizard; Using the Data Object Editor; Summary; 5. Extract, Transform, and Load Basics; ETL; Manual ETL processes; Staging; To stage or not to stage; Configuration of a staging area; Mappings and operators in OWB; The canvas layout; OWB operators; Source and target operators.