Preface

Purpose

Oracle Warehouse Builder is a comprehensive toolset for practitioners who move and transform data, develop and implement business intelligence systems, perform metadata management, or create and manage Oracle databases and metadata. This guide describes how to use Warehouse Builder Oracle MetaBase (OMB) Scripting Language to:

• Create a definition of a data warehouse.

• Configure the definitions for a physical instance of the data warehouse.

• Validate the set of definitions and their configurations.

• Generate a set of scripts to create and populate the data warehouse instance.

• Generate data transformation scripts.

• Deploy and initially load the data warehouse instance.

• Maintain the physical instance by conditionally refreshing it with generated scripts.

• Integrate Warehouse Builder metadata with other Business Intelligence products.

• Populate Oracle Discoverer EULs and OLAP catalogs for analyzing the data warehouse.

The guide also describes how to create and use Experts. It also lists the run-time and design time public views available in Warehouse Builder. It also describes how users can add new objects called user defined objects to Warehouse Builder.

Audience

This guide is intended for data warehouse practitioners who want to access Warehouse Builder functionality programmatically:

• Business Intelligence application developers

• Warehouse architects, designers, and developers—especially SQL and PL/SQL developers

• Developers of large-scale products based on data warehouses

• Warehouse administrators

• System administrators

• Other MIS professionals

In order to use the information in this guide, you need to be comfortable with the concepts of Relational Database Management Systems and Data Warehouse design. For information on data warehousing, refer to the Oracle Database Data Warehousing Guide. Also, you need to be familiar with Oracle's relational database software products such as Oracle Database, SQL*Plus, SQL*Loader, Oracle Enterprise Manager, and Oracle Workflow.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Related Documents

The Warehouse Builder documentation set includes these manuals:

• Oracle Warehouse Builder Concepts

• Oracle Warehouse Builder Installation and Administration Guide for Windows and Linux

• Oracle Warehouse Builder Sources and Targets Guide

• Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide

In addition to the Warehouse Builder documentation, you can refer to other documents listed below:

• Oracle Database Data Warehousing Guide

Oracle provides additional information sources, including other documentation, training, and support services that can enhance your understanding and knowledge of Oracle Warehouse Builder.

• For more information on Oracle Warehouse Builder technical support, contact Oracle World Wide Support services at:

  http://www.oracle.com/support

• For the latest information on, and downloads of, software and documentation updates to Oracle Warehouse Builder, visit My Oracle Support at:

  http://support.oracle.com

• You can order other Oracle documentation at:

  http://shop.oracle.com

Conventions

In this manual, Windows refers to the Windows NT, Windows 2000, and Windows XP operating systems. The SQL*Plus interface to Oracle Database may be referred to as SQL.

In the examples, an implied carriage return occurs after each line, unless otherwise noted. You must press the Return key after each line of input.

The following conventions are also used in this manual: