Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 What's New in Oracle Warehouse Builder

• New Feature Highlights for Oracle Warehouse Builder 11g Release 2 (11.2)
• New Features by Group for Oracle Warehouse Builder 11g Release 2 (11.2)
  • Native Support for Heterogeneous Databases
  • SOA Integration Enhancements for ETL and Data Quality
  • Data Warehousing and Business Intelligence Enhancements
  • Developer Usability Enhancements
  • Administrator Usability Enhancements
  • ETL Mapping Enhancements
  • Process Flow Enhancements
• Complete New Feature List for Oracle Warehouse Builder 11g Release 2 (11.2)
  • Advanced Find Support in Mapping Editor
  • Oracle Business Intelligence Enterprise Edition Integration
  • OLAP Cube-Organized Materialized Views Support
  • Code Template Mappings and JDBC Connectivity Support
  • Copy and Paste of Operators and Attributes in Mapping Editor
  • Current Configuration Drop-down Box in Design Center Toolbar
  • Enhanced Support for Flat File Imports
  • Enhanced Table Function Support
  • Experts Available in Editor Menus
  • Expression Editing in Operator Edit Dialog
  • Extensible Platform Framework
  • Automated Orphan Management Policy for Loading Dimensional Objects
  • Grouping and Spotlighting of Objects in Mapping Editor
  • Heterogeneous Audit and Reporting
  • Improved Management of Locations Registered in Multiple Control Centers
  • Improved Metadata Search and Find for Dependency Management
  • Improved User Interface for Managing Locations (for Sources and Targets)
  • Java-Based (J2EE) Control Center Agent
  • Key Lookup Operator Enhancements
  • Mapping Debugger Enhancements
  • Metadata Import from COBOL Copybooks
  • Multiple Configuration Management Usability Improvements
  • New JDeveloper-Style User Interface
  • Operator Comments Included in Generated PL/SQL Code
  • Organizing Objects with User Folders
  • Quick Mapper in Mapping Connection Dialog Box
  • Repository Browser Changes
  • Chunking for Parallelizing Large Table Updates
  • Simplified Oracle Warehouse Builder Repository Upgrades
  • Support for EJB/Java Activity Type in Process Flows
  • Improved Code Generation for Extraction of Peoplesoft Application Data
  • Support for OMB*Plus Activity Type In Process Flows
  • Support for Subqueries in Join Operator
  • Web Service and SOA Integration Support for ETL and Data Quality

2 Introduction to Oracle Warehouse Builder

• Overview of Oracle Warehouse Builder and Its Benefits
  • Use Cases for Oracle Warehouse Builder
• Quick Start for Using Oracle Warehouse Builder
  • Before You Begin
  • Configure a Project in the Oracle Warehouse Builder Design Center
  • Import the Source Metadata
  • Profile Data and Ensure Data Quality
  • Design the Target Schema
  • Design ETL Logic
  • Deploy the Design and Execute the Data Integration Solution
  • Monitor Quality and Report on the Data System
• Oracle Warehouse Builder Architecture
  • The Oracle Warehouse Builder Repository
  • Workspaces
  • Control Center Service
  • Control Center Agent (J2EE Runtime)
  • Target Schemas
• Getting Help for Oracle Warehouse Builder
  • Help Menu
  • Help Center
• Documentation Library for Oracle Warehouse Builder

3 User Interface Tour

• Workspaces
• Projects
  • Modules
  • Folders
  • Collections
• Design Center
  • Design Center Menus
  • The Design Center Toolbar
  • OMB*Plus
• Control Center Manager
• Navigators
  • Projects Navigator
  • Locations Navigator
    • Connectors Navigator of Locations
  • Globals Navigator
• Editors
  • Common Editor Components
    • Editor Windows
    • Mapping Navigator
    • Properties Inspector
    • New Gallery
    • Palette
    • Editor Toolbars
    • Editor Display Options
    • Data Viewer
    • Generation
• Wizards
• Repository Browser

4 Data Access and Movement

• About Metadata on Source Data
  • The Import Metadata Wizard
• Modules and Locations
  • About Connectors
• Summary of Supported Sources and Targets
• Flat Files as Data Sources or Targets
  • External Table Option
  • Flat File Operators
• Data Systems Access with Code Templates
• Generic Connectivity and Oracle Database Gateways
• Transportable Modules for Moving Large Volumes of Data

5 Data Objects

• Types of Data Objects
  • Data Object Editors
  • Data Viewers
• Dimensional Objects: Dimensions and Cubes
  • ROLAP versus MOLAP Implementations
  • About Creating and Using Cubes and Dimensions
    • Dimension Creation
    • Dimension Implementation
    • Dimension Deployment
    • Dimension Loading
    • About the OLAP Catalog
    • Orphan Management Policy for Dimensions
• Relational Dimensions
  • Rules for Dimension Objects
  • About Defining a Dimension
    • Defining Dimension Attributes
    • Defining Levels
    • Defining Level Attributes
    • Defining Hierarchies
    • Dimension Roles
    • Level Relationships
    • Control Rows
    • Value-based Hierarchies
  • Implementing a Dimension
    • Star Schema
    • Snowflake Schema
• Slowly Changing Dimensions (SCDs)
  • About Type 1 Slowly Changing Dimensions
• Time Dimensions
• Cubes: Measures and Dimensionality
  • Cube Definitions
    • Cube Measures
    • Cube Dimensionality
  • Implementing a Cube
    • Relational and ROLAP Implementation of a Cube
    • MOLAP Implementation of a Cube
  • Solve Dependency Order of Cube

6 Data Transformation

• Data Transformation with Oracle Warehouse Builder Mappings
• Data Flow and Transformation-Code Generation in Mappings
• Mapping Operators
• Pluggable Mappings
• Transformations for Designing Mappings
  • Predefined Transformations and Custom Transformations
  • Transformation Libraries
• Table Functions

7 Dependency and Change Management

• Metadata Security Concepts
  • About the Security Service
• Metadata Lifecycle Management Concepts
• The Metadata Loader
• Metadata Snapshots
  • About Managing Snapshots
• The Metadata Dependency Manager (MDM)
  • The Metadata Dependency Manager Menus and Commands
• Metadata Dependencies and Lineage and Impact Analysis
  • Lineage and Impact Analysis Diagrams

8 Data Quality Management

• About Data Quality Management Processes and Phases
  • Phases in the Data Quality Lifecycle
    • Quality Assessment
    • Quality Design
    • Quality Transformation
    • Quality Monitoring
• Data Profiling: Assessing Data Quality
• Data Rules: Enforcing Data Quality
• Data Auditors: Monitoring Data Quality
• Oracle Warehouse Builder Data Profiling Features
• Types of Data Profiling
  • Attribute Analysis
  • Functional Dependency Analysis
  • Referential Analysis
  • Custom Profiling with Data Rules
  • Six Sigma Methodology
    • What is Six Sigma?
    • Six Sigma Metrics for Data Profiling
• Automated Data Cleansing
  • Automatic Data Correction Based on Data Profiling Results
    • Types of Corrections for Source Data
    • Quick Summary of Performing Data Correction
• Match and Merge Operations

9 Deployment and Execution

• About Deploying and Executing Design Objects
  • Deployment Concepts
    • Deployment Status: Viewing Results
  • About Executing Design Objects
• Overview of Deployment and Execution Procedures
• Runtime Auditing for Deployments and Executions
• About Scheduling Design Objects to Execute

10 Scripting and Automation

• OMB*Plus Concepts
  • OMB*Plus from the Design Center
  • OMB*Plus from the Command Line
    • OMB*Plus and Windows Systems
    • OMB*Plus and Linux and UNIX
• Overview of Experts in Oracle Warehouse Builder
  • Design Environment for Experts
  • Storage of Experts: Public and Private
• About Guided Assistance Experts

A Oracle Warehouse Builder Design Center and Runtime Preferences

• About Design Center Preferences
  • Code Template Editor Preferences
  • Control Center Monitor Preferences
  • Data Profiling Preferences
  • Deployment Preferences
  • Environment Preferences
  • Expert Editor Preferences
  • Generation/Validation Preferences
  • Lineage and Impact Analysis Preferences
  • Logging Preferences
  • Mapping Editor Preferences
  • Naming Preferences
    • About Naming Modes
  • Process Flow Editor Preferences
  • Recent Logons Preferences
  • Security Parameters
• About Runtime Preferences
  • External Activity Security - Constraints
  • External Activity Security - Proxy Command
  • Version Checking Management
  • Connection Pooling
  • Garbage Collection
  • Connection Timezone
  • JVM Timezone
  • Connection OCI Fix
  • JVM Properties
  • Runtime Logging

B Object Editors

• The Graphical Navigator and Editors
• Data Object and Document Editors

Glossary

Index