Skip Headers
Oracle® Warehouse Builder User's Guide
10
g
Release 1 (10.1)
Part Number B12146-02
Home
Book List
Index
Contact Us
Next
View PDF
Contents
Title and Copyright Information
Preface
Purpose
Audience
Documentation Accessibility
How This Guide Is Organized
New in 10
g
Release 1 (10.1)
Added in 10
g
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 Oracle9
i
AS 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 6
i
/9
i
Sources
Using Designer 6
i
/9
i
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 Oracle9
i
OLAP Server
Notes on the OLAP Import
Exporting Metadata to Oracle Discoverer 4
i
and 9
i
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 Oracle9
i
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