Packt Publishing Community Experience, Distilled

Oracle Warehouse Builder 11g: Getting Started Table Of Contents

HomeBooksSupportFreeAuthorsAward
WELCOME YOUR ACCOUNT NEWSLETTERS ARTICLES ABOUT US

 
Oracle Warehouse Builder 11g: Getting Started Table Of Contents
Back to BOOK PAGE

Table of Contents

Preface
Chapter 1: An Introduction to Oracle Warehouse Builder
Chapter 2: Defining and Importing Source Data Structures
Chapter 3: Designing the Target Structure
Chapter 4: Creating the Target Structure in OWB
Chapter 5: Extract, Transform, and Load Basics
Chapter 6: ETL: Putting it Together
Chapter 7: ETL: Transformations and Other Operators
Chapter 8: Validating, Generating, Deploying, and Executing Objects
Chapter 9: Extra Features
Index
Up
  • Chapter 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 systems
      • Installing Oracle database software
      • Configuring the listener
      • Creating the database
      • Installing the OWB standalone software
      • OWB components and architecture
      • Configuring the repository and workspaces
    • Summary
    Up
    • Chapter 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 module
        • Importing source metadata from a database
        • Defining source metadata manually with the Data Object Editor
        • Importing source metadata from files
      • Summary
      Up
      • Chapter 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
        Up
        • Chapter 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 Wizard
            • The 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
          Up
          • Chapter 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
                • Data flow operators
                • Pre/post-processing operators
            • Summary
            Up
            • Chapter 6: ETL: Putting it Together
              • Designing and building an ETL mapping
                • Designing our staging area
                  • Designing the staging area contents
                  • Building the staging area table with the Data Object Editor
                • Designing our mapping
                  • Review of the Mapping Editor
                  • Creating a mapping
              • Summary
              Up
              • Chapter 7: ETL: Transformations and Other Operators
                • STORE mapping
                  • Adding source and target operators
                  • Adding Transformation Operators
                  • Using a Key Lookup operator
                    • Creating an external table
                    • Creating and loading a lookup table
                    • Retrieving the key to use for a Lookup Operator
                    • Adding a Key Lookup operator
                • PRODUCT mapping
                • SALES cube mapping
                  • Dimension attributes in the cube
                  • Measures and other attributes in the cube
                  • Mapping values to cube attributes
                    • Mapping measures' values to a cube
                    • Mapping PRODUCT and STORE dimension values to the cube
                    • Mapping DATE_DIM values to the cube
                • Features and benefits of OWB
                • Summary
                Up
                • Chapter 8: Validating, Generating, Deploying, and Executing Objects
                  • Validating
                    • Validating in the Design Center
                    • Validating from the editors
                      • Validating in the Data Object Editor
                      • Validating in the Mapping Editor
                  • Generating
                    • Generating in the Design Center
                    • Generating from the editors
                      • Generating in the Data Object Editor
                      • Generating in the Mapping Editor
                  • Deploying
                    • The Control Center Service
                    • Deploying in the Design Center and Data Object Editor
                    • The Control Center Manager
                      • The Control Center Manager window overview
                      • Deploying in the Control Center Manager
                  • Executing
                  • Deploying and executing remaining objects
                    • Deployment Order
                    • Execution order
                  • Summary
                  Up
                  • Chapter 9: Extra Features
                    • Additional editing features
                      • Metadata change management
                        • Recycle Bin
                        • Cut, copy, and paste
                        • Snapshots
                        • Metadata Loader (MDL) exports and imports
                      • Synchronizing objects
                        • Changes to tables
                        • Changes to dimensional objects and auto-binding
                    • Warehouse Builder online resources
                    • Summary
                    Up
                    Back to BOOK PAGE


                       




                    © Packt Publishing Ltd 2010

                    RSS