Contents

Title and Copyright Information

Preface

• Purpose
• Audience
• Documentation Accessibility
• How This Guide Is Organized
• New in 10g Release 1 (10.1)
• Added in 10g Release 1 (10.1)
• Conventions
• Related Publications
• Contacting Oracle

1 Overview of Oracle Warehouse Builder

• Product Architecture and Capabilities
  • The Design Component
  • The Runtime Component
  • How Warehouse Builder Achieves Its Goal
  • Warehouse Builder Components
    • Warehouse Builder Client Application
    • Warehouse Builder Runtime Platform Service
    • Warehouse Builder Design Repository
    • Warehouse Builder Runtime Repository
    • Audit Reporting Browser
    • Metadata Reporting Browser
  • Warehouse Builder Objects
  • Warehouse Builder Deployment Targets
• Benefits of Using Warehouse Builder

2 Getting Started with Warehouse Builder

• Overview of Creating a Business Intelligence System
  • Step 1: Creating a Project
  • Step 2: Defining Source and Target Modules
    • Defining Sources
    • Defining Targets
    • Defining Locations and Connectors
    • Configuration
  • Step 3: Defining Data Movement and Transformation
    • Configuration
  • Step 4: Validating and Generating
    • Validation
    • Generation
  • Step 5: Deploying and Executing
    • Creating a Runtime Repository Connection
    • Using the Deployment Manager
    • Viewing Deployment and Execution Audit Reports
• Accessing the Warehouse Builder Repository
  • Multiple User Account System
    • Registering a Warehouse Builder User
    • Other User Management Utilities
    • How the Multiple User Account System Works
  • Security Registration Service
    • Privileges
    • Post Installation
  • Security Requirements
• Starting Warehouse Builder
  • For Windows NT/2000/XP Users
  • For UNIX Users
  • Closing Warehouse Builder
    • Committing Your Work
• Supporting Multiple Users
  • Read/Write Mode
  • Read-Only Mode
  • Synchronization
• Introducing the Console
  • The Project Navigation Tree
  • The Toolbar
• Setting Preferences
  • General Preferences
  • Naming Preferences
    • About Naming Modes
    • Setting the Name Mode
  • Message Log Preferences
  • Utilities Preferences
    • Adding a Utility
    • Updating a Utility
    • Removing a Utility
  • Browser Preferences
    • Using the Client Version
    • Using the Oracle9iAS Version
  • Clipboard/Recycle Preferences
    • Clipboard Persistence Properties
    • Recycle Bin Persistence Properties
• Creating and Editing Warehouse Builder Objects
  • Creating Projects
    • Creating a New Project
    • Deleting Projects
  • Using the Warehouse Builder Wizards
  • Using Object Editors
  • Using Property Sheets
  • Creating User-Defined Properties
  • Finding Objects in a Project
• Managing Metadata
  • Metadata Reporting
  • Metadata Import and Export
  • Metadata Exchange
    • Defining Collections
    • Using the Warehouse Builder Transfer Wizard

Part I Defining Source and Target Objects

3 Defining Oracle Data Objects

• Creating Warehouse Modules
  • Defining Locations
    • Creating Locations
    • Editing Locations
  • Defining Connectors
    • Creating Connectors
    • Editing Connectors
• About Data Objects
• Using Tables
  • Creating a Table Definition
    • Creating a Table with the New Table Wizard
  • Using the Table Editor
    • Displaying Related Tables
    • Validating Table Definitions
    • Viewing Reports
  • Editing Table Definitions
  • Renaming a Table
  • Adding Columns
    • Available Data Types
  • Reordering Columns in a Table
  • Editing Constraints
    • Defining Constraints in Warehouse Builder
  • Deleting Constraints
  • Adding Attribute Sets
• Using External Tables
  • About External Tables
    • External Tables versus Flat File Operators
  • Creating a New External Table Definition
  • Using the External Table Editor
  • Reconciling an External Table Definition with a Record in a File
  • Editing External Table Definitions
    • Access Parameters
• Using Views
  • About Views
  • Creating a View Definition
  • Editing a View Definition
• Using Materialized Views
  • About Materialized Views
  • Creating a Materialized View Definition
  • Editing a Materialized View Definition
• Using Sequences
  • About Sequences
  • Creating a Sequence Definition
  • Using the Sequence Editor
  • Editing Sequence Definitions
  • Renaming a Sequence
  • Editing Sequence Column Descriptions
• Using Advanced Queues
  • About Advanced Queues
    • Payloads
    • Messages
  • Creating Definitions for Advanced Queues
    • Importing AQ Definitions
  • Reimporting Advanced Queue Definitions
  • Viewing Advanced Queue Properties
  • Creating Advanced Queues Using SQL
  • Creating Advanced Queues Using Oracle Enterprise Manager
• Using Dimensions
  • Rules for Dimension Objects
    • About Levels and Hierarchies
    • About Unique Key Constraints
    • About Mixed Levels of Aggregation
  • Creating a Dimension Definition
  • Editing Dimension Definitions
    • Using the Dimension Editor
    • Using the Property Sheets
• Using Cubes
  • Creating Cube Definitions
  • Editing a Cube Definition
    • Using the Cube Editor
• Importing Metadata into Target Modules

4 Importing Data Definitions

• Creating Source Modules
  • Selecting the Type of Source Module to Create
  • Oracle Heterogeneous Services
  • Configuring Connections for Database Sources
• About Database Sources
  • Creating a Database Source Module
  • Importing Definitions from a Database
  • Re-Importing Definitions from an Oracle Database
  • Updating Oracle Database Source Definitions
    • Updating a Source Definition
    • Updating the Connection
    • Updating the Location
• Using Oracle Designer 6i/9i Sources
  • Using Designer 6i/9i as a Metadata Source
• About Flat File Modules
  • Creating Flat File Modules
• About Flat File Sources and Targets
  • Using the Import Metadata Wizard Flat Files
  • Using the Flat File Sample Wizard
  • Describing the Flat File
  • Selecting the Record Organization
    • Specifying Logical Records
  • Selecting the File Layout
  • Selecting the File Format
  • Selecting Record Types (Multiple Record Type Files Only)
    • Example: Flat File with Multiple Record Types
    • Defining Multiple Record Organization in a Delimited File
    • Defining Multiple Record Organization in a Fixed-Length File
  • Specifying Field Lengths (Fixed-Length Files Only)
    • Specifying Field Lengths for Multiple Record Files
  • Specifying Field Properties
    • SQL*Loader Properties
    • SQL Properties
  • Updating a File Definition
    • General Tab
    • Record Tab
    • Structure Tab

5 Configuring Data Objects

• Creating Indexes and Partitions
  • About Indexes
  • Creating Indexes
  • Creating Bitmap Indexes
  • Configuring Indexes
  • Renaming Indexes
  • About Partitions
  • Creating Partitions
    • Creating a Partition Key Entry
    • Creating Hash Partitions
    • Creating Range Partitions
    • Renaming Range Partitions
    • Partitioning Indexes
• Configuring Warehouse Builder Design Objects
• Configuring Target Modules
• Configuring Tables
  • Performance Parameters
  • Parallel
  • Storage Space
  • Identification
  • Indexes
  • Constraints
• Configuring External Tables
  • Access Specification
  • Reject
  • Parallel
  • Data Characteristics
  • Field Editing
  • Identification
  • Data Files
• Configuring Advanced Queues
• Configuring Dimensions
• Configuring Cubes
• Configuring Materialized Views
  • Materialized View Parameters
    • Build
    • Refresh
    • Query Rewrite
    • Base Tables
  • Fast Refresh for Materialized Views
• Configuring Views
• Configuring Sequences

Part II Designing ETL Objects

6 Designing Mappings

• About Mappings
  • About Oracle Warehouse Modules
  • Procedure for Defining Mappings
• Creating a Mapping
  • About the Mapping Editor
  • About Operators
    • Source and Target Operators
    • Data Flow Operators
• Adding Operators
  • Adding Bindable Operators
    • Create Unbound Object with No Attributes
    • Create New Repository Object and Bind
    • Import Object into Repository and Bind
    • Select from Existing Repository Object and Bind
• Editing Operators
  • Mapping Naming Conventions
    • Naming Conventions for Attributes and Groups
    • Naming Conventions for Operators
  • Using Display Sets
    • Defining Display Sets
    • Selecting a Display Set
  • Compressing Mappings
• Connecting Operators
  • Connecting Attributes
  • Connecting Groups
    • Example: Using the Mapping Editor to Create Staging Area Tables
    • Using the Auto-Mapping Dialog
    • Copy Source Attributes to Target Group with Existing Attributes
    • Match by Position of Source and Target Attributes
    • Match by Name of Source and Target Attributes
    • About Auto-Mapping Dialog Comments
• Setting Operator Properties
  • Source and Target Operator Properties
    • Bound Name
    • Primary Source
    • Loading Types for Oracle Target Operators
    • Loading Types for Flat File Targets
    • Target Filter for Update
    • Delete Target Condition
    • Match By Constraint
    • Key Name
    • Key Columns
    • Key Type
    • Referenced Keys
  • Attribute Properties
    • Bound Name
    • Data Type
    • Precision
    • Scale
    • Length
    • Load Column When Inserting Row
    • Load Column When Updating Row
    • Match Column When Updating Row
    • Update: Operation
    • Match Column When Deleting Row
  • Flat File Operators Properties
    • Loading Types
    • Field Names in the First Row
• Reconciling Operators and Repository Objects
  • Inbound Reconciliation
    • Reconciling Operators based on Repository Objects
  • Outbound Reconciliation
  • Match Strategies
    • Match by Object Identifier
    • Match by Bound Name
    • Match by Position

7 Debugging Mappings

• About Debug Mode in the Mapping Editor
  • Starting a Debug Session
  • Defining Test Data
    • Creating New Tables
  • Setting Breakpoints
  • Setting Watches
  • Running the Mapping
    • Selecting a Leading Source and Path
    • Step Data Panel
    • Debugging Mappings with Correlated Commit
  • Re-Initializing a Debug Session
• Scalability
• Restrictions

8 Using Mapping Operators

• Using the Expression Builder
  • Opening the Expression Builder
    • The Expression Builder User Interface
• Aggregator Operator
  • Defining the Output Attributes from Aggregator Operators
• Constant Operator
• Data Generator Operator
  • Setting a Column to the Data File Record Number
  • Setting a Column to the Current Date
  • Setting a Column to a Unique Sequence Number
• Deduplicator Operator
• Expression Operator
• Filter Operator
• Joiner Operator
  • Joiner Restrictions
  • Specifying a Full Outer Join
  • Creating Full Outer Join Conditions
• Key Lookup Operator
• Mapping Advanced Queue Operator
  • Creating AQ Mappings
    • Example of an AQ in a Mapping
    • Reconciling Advanced Queues
  • Advanced Queue Operator Properties
    • General
    • Groups
    • Input/Output
  • AQ Prerequisites for Mapping Execution
    • Registering AQ as a Subscriber
• Mapping Flat File Operator
  • Flat File Source Operators
  • Flat File Target Operators
  • Using Previously Imported Flat Files
  • Importing and Binding New Flat Files into Your Mapping
  • Defining New Flat File Sources or Targets in Mappings
  • Extracting a Master-Detail Structure from Flat Files
    • Maintaining Relationships Between Master and Detail Records
    • Extracting and Loading Master-Detail Records
    • Error Handling Suggestions
    • Direct Path Loading for Performance
    • Subsequent Operations
• Mapping Input Parameter Operator
• Mapping Output Parameter Operator
• Mapping Sequence Operator
• Match-Merge Operator
  • Example: Matching and Merging Customer Data
  • Designing Mappings with a Match-Merge Operator
  • Using the Match-Merge Operator
    • General
    • Groups
    • Input Connections
    • Input Attributes
    • Merge Output
    • Cross Reference Output
    • Match Bins
    • Match Rules
    • Active Match Rules
    • Passive Match Rules
    • Custom Match Rule
    • Merge Rules
    • Custom Merge Rule
  • Understanding Matching Concepts
    • Example of Multiple Match Rules
    • Example of Transitive Matching
    • Address Match Rule
    • Conditional Match Rule
    • Firm Match Rule
    • Person Match Rule
    • Weight Match Rule
    • Example of a Weight Match Rule
  • Refining Data from Match-Merge Operators
• Name and Address Operator
  • About the Name and Address Operator
  • Example: Following a Record Through the Name and Address Operator
    • Example Input
    • Example Steps
    • Example Output
  • Using the Name and Address Operator in a Mapping
    • General
    • Definitions
    • Groups
    • Input Connections
    • Input Attributes
    • Output Attributes
    • Postal Report
  • Postal Reporting
    • Accessing the Postal Report Files
    • Postal Report Restrictions for International Data
• Pivot Operator
  • Example: Pivoting Sales Data
  • The Row Locator
  • Using the Pivot Operator
    • General
    • Groups
    • Input Connections
    • Input Attributes
    • Output Attributes
    • Pivot Transform
• Post-Mapping Process Operator
• Pre-Mapping Process Operator
• Set Operation Operator
• Sorter Operator
• Splitter Operator
  • Example: Creating Mappings with Multiple Targets
• Table Function Operator
  • Prerequisites for Using the Table Function Operator
    • Input
    • Output
  • Table Function Operator Properties
    • General
    • Input Parameter Group
    • Input Parameter
    • Output Parameter Group
    • Output Parameter
• Transformation Operator
• Unpivot Operator
  • Example: Unpivoting Sales Data
  • The Row Locator
  • Using the Unpivot Operator
    • General
    • Groups
    • Input Connections
    • Input Attributes
    • Row Locator
    • Output Attributes
    • Unpivot Transform

9 Using Transformations

• About Transformations
  • About Custom Transformations
  • About Pre-Defined Transformations
• Defining Custom Transformations
• Importing PL/SQL
• Editing Transformation Properties

10 Designing Process Flows

• About Process Flows
  • About Process Flow Modules
  • About Process Flow Packages
• Procedure for Defining Process Flows
  • Creating Process Flow Modules
  • Creating Process Flow Packages
  • Creating Process Flow Definitions
• About the Process Flow Editor
  • Navigating in the Process Flow Editor
  • About Activities
    • Adding Activities
    • Binding and Passing Parameters to Activities
  • About Transitions
    • Connecting Activities
  • Using Activities in Process Flows
    • AND
    • Email
    • End
    • External Process
    • File Exists
    • FORK
    • FTP
    • Mapping
    • OR
    • Start
    • Subprocess
    • Transform
• Process Flow Editor Menu and Toolbar
  • Menu Bar
    • Process Flow
    • Edit
    • View
    • Window
    • Help
  • Toolbar

11 Configuring ETL Objects

• Configuring Mappings Reference
  • Procedure for Configuring Mappings
  • Runtime Parameters Reference
    • Default Operating Mode
    • Bulk Size
    • Default Audit Level
    • Maximum Number of Errors
    • Commit Frequency
    • Default Purge Group
    • Analyze Table Sample Percentage
  • Code Generation Options Reference
    • Bulk Processing Code
    • Row Based Mode
    • Parallel Row Code
    • Analyze Table Statements
    • Optimized Code
    • Correlated Commit
  • Sources and Targets Reference
    • Bound Name
    • Schema
    • Database Link
    • Partition Exchange Loading
    • Hints
    • Constraint Management
    • SQL*Loader Parameters
  • Configuring Flat File Operators
  • Flat File Operators as a Target
  • Flat File Operator as a Source
• Strategies for Configuring PL/SQL Mappings
  • Selecting a Default Operating Mode
    • Set based
    • Row based
    • Row based (Target Only)
  • Committing Data from a Single Source to Multiple Targets
    • Commit Strategies
    • Using the Correlated Commit Strategy
  • Avoiding Invalid Designs for PL/SQL Mappings
• Using Partition Exchange Loading
  • About Partition Exchange Loading
  • Configuring a Mapping for PEL
  • Direct and Indirect PEL
    • Using Indirect PEL
    • Example: Using Direct PEL to Publish Fact Tables
  • Using PEL Effectively
  • Configuring Targets in a Mapping
    • Step 1: Create All Partitions
    • Step 2: Create All Indexes Using the LOCAL Option
    • Step 3: Primary/Unique Keys Use "USING INDEX" Option
  • Restrictions for Using PEL in Warehouse Builder
• Configuring Process Flows

Part III Deploying and Executing

12 Validating Objects

• About Validation
• Validating Objects
• Viewing the Validation Results
  • The Validation Results Navigation Tree
  • The Validation Messages
    • Message Editor Button
    • Object Editor Button
    • View Details Button
• Editing Invalid Objects
• Viewing Generated Scripts
  • Generating Scripts
  • Viewing the Generation Results
  • Viewing the Scripts
  • Saving the Scripts

13 Deploying Target Systems

• About Deployment
• Deploying and Upgrading Target Systems
  • Defining Runtime Repository Connections
    • Creating Runtime Repository Connections
    • Editing Runtime Repository Connections
  • Deploying Objects
• Using the Deployment Manager
  • Opening the Deployment Manager
  • About the Deployment Manager
    • Deployment Tree
    • Details Tab
    • History Tab
    • Toolbar
• Registering Locations
  • Database Connections
  • Location Registration
    • For Oracle Locations:
    • For Non-Oracle Locations:
    • For File System Locations:
    • For Oracle Enterprise Manager Locations:
    • For Oracle Workflow Locations:
    • For SAP Locations:
• Selecting Objects for Deployment
  • Viewing Deployment History
  • Completing the Deployment
• Saving Deployment Scripts
• Executing Deployed Objects
  • Executing Mappings and Process Flows
    • Using Other Tools to Execute Process Flows
    • Executing Mappings and Process Flows Using SQL*Plus
• Scheduling Mappings and Process Flows

14 Auditing Deployment and Execution

• Why Audit Deployments and Executions?
• About the Runtime Audit Browser
  • Starting the Client Browser Version
  • Starting the Oracle Portal Version
    • Selecting a Role
• Viewing Runtime Repository Reports
  • Viewing Deployment Reports
    • Deployment Schedule
    • Object Summary
    • Location
  • Viewing Execution Reports
    • Execution Schedule
    • Execution Summary
    • Execution
    • Trace
  • Purging Audit Data
• Runtime Audit Browser Administration
  • Managing Available Repositories
    • Registering a Repository
    • Editing Repository Definitions
    • Managing Database Links
    • Creating Database Links
    • Editing Database Links
    • Viewing the Database Link Error Status Page
  • Administering Roles
  • Maintaining the Administrator List
• Available Runtime Audit Reports
  • Warehouse/Repository Reports
  • Process Reports
  • Process Run Reports
  • Mapping Reports
  • Mapping Execution Reports
  • Execution Error Reports
  • Data Object Reports
  • Location Reports
  • Deployment Error Reports
  • Management Reports

Part IV Managing Metadata

15 Importing and Exporting with the Metadata Loader (MDL)

• Overview of Import and Export Using Metadata Loader
• Importing and Exporting Metadata Using the Metadata Loader
  • Required Access Privileges for MDL
  • About Metadata Loader Results
    • About the Metadata Loader Log File
    • Detailed Error Logs
• Exporting Metadata
  • Before Exporting Metadata
  • About the Metadata Export Utility
  • Exporting Metadata using Warehouse Builder Client
  • Metadata Export File Format
  • Archiving a Project
    • Project Version Labels
    • Differences Between Archive and Export
    • Archiving a Project
• Importing Metadata
  • Before Importing Metadata
  • About the Metadata Import Utility
  • Validation Rules Governing Import
  • Importing Metadata using Warehouse Builder Client
    • Import Modes
    • Metadata Matching Criteria
  • Restoring a Project
    • Differences Between Restore and Import
    • Restoring a Project
• Using the Metadata Loader Command Line Utility
  • Creating MDL Parameter Files at the Command Line
  • Exporting Metadata Using the Command Line Utility
    • Keywords for the Export Utility
  • Importing Metadata Using the Command Line Utility
    • Keywords for the Import Utility
• Splitter for Exporting and Importing Warehouse Builder Mappings

16 Metadata Change Management

• About Metadata Snapshots
  • Snapshots and Deleting Objects
• Snapshot Types
  • Full and Signature Snapshots
  • Cascade and No Cascade Snapshots
  • Snapshot Combinations
• Creating Snapshots
• Updating Snapshots
• Metadata Change Management Window
• Compare Snapshots
  • Snapshot Comparison Dialog
  • Considerations
• Restore Snapshots
• Delete Snapshots
• Using Metadata Snapshots
  • History Management
    • Creating Snapshots
    • Deleting Snapshots
    • Altering Snapshots
    • Restoring Snapshots
    • Exporting and Importing Snapshots
  • Change Management
    • Listing Snapshots
    • Retrieving Information About Snapshots
    • Comparing Snapshots
• Snapshot Usage Suggestions
  • Using Snapshots in Conjunction with Other Warehouse Builder Functionality
  • Snapshot Views for Data Warehouse Designers and Managers

17 Metadata Browsing and Reporting

• About Warehouse Builder Design Browser
  • Navigator Portlet
  • Favorites Portlet
  • Reports Portlet
• Using Warehouse Builder Design Browser
  • Starting Warehouse Builder Design Browser
    • Starting the Portal Version of the Design Browser
  • Navigating Warehouse Builder Browser
    • Header Section
    • Path Section
    • Body Section
    • Properties Tab
    • Contents Tab
    • Related Tab
    • Reports Tab
    • Links Tab
  • Browsing Favorites
    • General Page Information
    • Favorites Filter
    • Navigation Favorites
    • Report Favorites
  • Customizing Your Favorites Page
• Viewing Warehouse Builder Reports
  • Viewing Reports in the Warehouse Builder Client
    • Viewing a Custom Report
  • Viewing Reports in Warehouse Builder Browser
  • Warehouse Builder Metadata Reports
    • Summary Reports
    • Detailed Reports
    • Implementation Reports
    • Lineage and Impact Analysis Reports and Diagrams
    • Lineage and Impact Analysis Diagrams

18 Managing Warehouse Builder Browser

• Warehouse Builder Browser Overview
  • About Oracle DatabaseAS Portal
  • Portlets for Managing Warehouse Builder Browser
    • Launcher Portlet
    • Administration Portlet
    • Reports Portlet
• Adding Portlets
• Administering Warehouse Builder Browser
  • Register a Warehouse Builder Repository
    • Managing Repositories
    • Creating Database Links
    • Viewing a Database Link
    • Editing a Database Link
    • Dropping a Database Link
    • Unregistering a Repository
  • Register a Custom Report
    • Adding a Custom Report to a Role
  • Resource Management
    • Adding User Accounts
    • Managing Custom Reports
  • Managing Preferences
    • Saving Preferences
    • Loading Preferences
  • Managing the Dependency Index
    • Setting the Refresh Options
    • Refreshing the Dependency Index on Demand
  • Other Administration Tasks
  • Configuring the Warehouse Builder Client
• Creating Custom Reports
  • Creating a Custom Report in Oracle Portal

Part V Integrating and Extending Warehouse Builder

19 Extending Warehouse Builder Functionality

• About Oracle Metabase (OMB) Plus
• User-Defined Properties
  • Managing User Defined Properties
    • OMBDEFINE
    • OMBDESCRIBE
  • Viewing User Defined Properties
    • Warehouse Builder Client
    • Warehouse Builder Design Browser
  • Transferring UPDs to Other Repositories
    • Exporting UDPs
• Managing Security with PL/SQL
  • Maintaining Repository Users
  • Plug-in Interface for the Security PL/SQL Package Specification
  • Definitions of the Constants in the Package Specification
  • Implementing the PL/SQL Interface
    • Considerations
• Implementing Sample Security Policies
  • The Warehouse Builder Security Architecture
  • Using a Customizable Security Authorization Framework
    • Freezing Projects
  • Development Cycle Based Security
  • Reactive Security and Audit-based Security
  • Data Stewardship

20 Data Quality: Name and Address Cleansing

• Input Roles
• Output Components
• Name and Address Operator Supported Countries
• Country Postal Certifications
  • United States Postal Service CASS Certification
  • Canada Post SERP Certification
  • Australia Post AMAS Certification
• Configuring the Name and Address Server
• Starting and Stopping the Name and Address Server
• Best Practices for Using the Name and Address Operator in a Mapping
  • Correcting Errors in Name and Address Data
  • Using Status Codes
  • Using Discrete Input Roles
  • Separating Good Records from Bad Records with the Splitter Operator

21 Using SAP R/3 Data in Warehouse Builder

• About the Warehouse Builder SAP Integrator
  • About SAP Business Areas
  • SAP Table Types
  • Required Files For Windows
  • Required Files For Unix
• Defining SAP Metadata Objects
  • Creating SAP Module Definitions
  • Importing SAP Metadata Definitions
    • Opening the Import Metadata Wizard
    • Filtering SAP Metadata
    • Re-importing SAP Objects
  • Updating SAP Source Modules
• Defining the ETL Process for SAP Objects
  • Defining Mappings Containing SAP Objects
    • Adding SAP Objects to a Mapping
    • Using the Copy and Map Wizard To Define a Target
  • Configuring Code Generation for SAP Objects
    • Setting the Loading Type
    • Setting the Step Type Parameter
    • Setting the Runtime Parameters
    • Setting the Generation Target Directories
  • Generating SAP Definitions
• Loading SAP Data into the Repository
  • Deploying PL/SQL Scripts for Transparent Tables

22 Integrating Warehouse Builder Metadata with Other BI Products

• Overview of Warehouse Builder Integration Features
• Defining Collections
  • Creating a Collection
  • Editing a Collection
• Business Intelligence Integration Using the Transfer Wizard
  • Integrating with the Meta Integration Model Bridges (MIMB)
    • Download the Meta Integration Model Bridge
  • Importing Metadata into Warehouse Builder
  • Exporting Metadata from Warehouse Builder
• Online Analytical Processing (OLAP) with Warehouse Builder
  • About the Analytic Workspace
• Enabling OLAP with Warehouse Builder
  • Creating the OLAP Metadata
    • Defining OLAP Dimensions in Warehouse Builder
    • Defining Cubes in Warehouse Builder
  • Defining Collections in Warehouse Builder
  • Deploying OLAP Metadata Using the Warehouse Builder Transfer Wizard
    • Generate and Deploy DDL Scripts
    • Deploy Metadata Using the Warehouse Builder Transfer Wizard
    • Debugging the Export to OLAP
  • Loading the Analytic Workspace
    • Creating a Mapping to Load an Analytic Workspace
    • Creating a Process Flow to Load an Analytic Workspace
  • Debugging the Cloning in a Mapping or Process Flow
  • Notes on the Warehouse Builder OLAP Bridge (9.0.5)
  • Execution Modes for the Warehouse Builder OLAP Bridge
    • Standard Mode: Deploying PLSQL from Bridge
    • Debug mode: Deploying PLSQL manually
  • Customizing the Bridge
  • Cloning Behavior (Incremental Loading, Precalculated Aggregation)
    • Incremental Loading
    • Pre-Calculated Aggregation
• Warehouse Builder Bridges: Transfer Parameters and Considerations
  • Transfer Parameters
  • Transfer Considerations
  • Importing Metadata from an Object Management Group CWM Standard System
  • Importing Metadata from Computer Associates ERwin 3.5.1
  • Importing Metadata from Powersoft PowerDesigner 6.0
  • Importing Metadata from Oracle9i OLAP Server
    • Notes on the OLAP Import
  • Exporting Metadata to Oracle Discoverer 4i and 9i
    • Configuring Warehouse Builder for Dimensional Reuse
    • Defining Dimensions and Cubes in Warehouse Builder
    • Defining the Dummy Tables
    • Hiding Data Prior to Transfer
  • Importing Transferred Data into Discoverer
    • Dimensional Reuse Naming Conventions in Discoverer
  • Exporting Metadata to an Object Management Group CWM Standard System
  • Exporting Metadata to Oracle Express
    • OSA Configuration
  • Exporting Metadata to Oracle9i OLAP Server

Part VI Appendix

A Keyboard Shortcuts

• General Windows Keys
• Tree View Control Keys
• Accelerator Keys Set for Warehouse Builder
• Menu Commands and Access Keys
• Mapping Editor Keyboard Operations
• Auto-Mapping Mnemonic Key Assignments

B Reserved Words

• Reserved Words

C Using the XML Toolkit

• Overview
• Retrieving Data From Sources
• Storing Data in Targets
• Using Runtime Controls
• Calling the XML Toolkit
  • Two Entrances
  • Typical Control Files
  • XML Documents Stored in Files
    • The XML Document
    • The Target Table
    • The Control File
    • About the dateFormat Attribute
    • A Warehouse Builder Transformation
    • The Target Table
    • The Control File
    • The Style Sheet
    • A Warehouse Builder Transformation
    • Multiple Targets
  • XML Documents Stored as Other Objects
    • Document Stored as a CLOB
    • Document Stored as an Object-Based Advanced Queue
    • Document Stored at a URL
  • Control File Element Names and Attributes
    • Source Elements
    • Target Elements
    • Runtime Control
  • Document Type Definition for the Control File
  • Reference Materials

D Warehouse Builder Public Views

• Warehouse Builder Design Repository Public Views
  • General Model Views
  • Data Model Views
  • Implementation Model Views
  • Flat Files Views
  • Collections Views
  • Function Model Views
  • Configuration Model Views
  • Deployment Model Views
  • Mapping Model Views
  • Process Flow Model Views
• Warehouse Builder Runtime Repository Public Views
  • Deployment Auditing Views
  • Execution Auditing Views

E Public Objects

• About First Class Objects
• About Second Class Objects
• About Third and Fourth Class Objects
• Warehouse Builder Class Definition Objects
• Object Ownership Tree

Glossary

Index