Breadcrumb

In this lesson, you use the setup files to configure the project environment for Oracle Warehouse Builder 11g Release 1 (OWB 11gR1). You then create a Warehouse Builder user and log in.

Designing a relational target warehouse in Warehouse Builder constitutes modeling relational (from 3rd normal form to dimensional) schemas that provide power to your data warehouse. Alternatively, you can also design a multidimensional system providing high-end analytics. In this lesson, you model a small data warehouse consisting of a cube and two dimensions. The source of data for the target warehouse is flat files.

This lesson describes how to design mappings and process flows, and use them to define data movement and transformation in Warehouse Builder. When you design a mapping in Warehouse Builder, you use the Mapping Editor interface. There is a large set of mapping operators available to you for use within the Mapping Editor. Oracle Warehouse Builder allows you to use activities external to Warehouse Builder (such as e-mail, FTP commands, and operating system executables). External activities will not be covered in this course. Using the Process Flow Editor, you learn how to design process flows that interrelate mappings and other activities. In this lesson, you learn how to create mappings to extract data from sources, transform it, and load it into targets. It also briefly introduces the Debugging Editor to debug data flows in the Mapping Editor.

Now you have easy access to information that you need to administer your Oracle Database with our downloadable Interactive Quick Reference. We have taken our traditional printed poster for Database Administrators, and created an electronic format packed with even more information. Use this helpful reference as a cheat sheet for writing custom data dictionary scripts, locating views pertinent to a specific database component, and more. This essential reference includes:

• Top DBA Views: Key DBA static data dictionary views and dynamic performance views organized by product feature areas
• Architecture: A single diagram that illustrates the relationships between key database memory structures, processes, and storage
• Background Processes: A comprehensive list that categorizes the background processes and flags which are new in Oracle

This OBE Series complements the Oracle Database 11g 2 Day DBA documentation.

In this self-study tutorial, Oracle Communications Data Model (OCDM) implementors are introduced to the OCDM product and the architecture of the OCDM data models and product stack. Tutorial text and diagrams introduce concepts and specific OCDM implementation procedures. Movies created with Qarbon ViewletBuilder provide interactive simulations of the tools used to customize OCDM.

In this self-study tutorial, Oracle Retail Data Model (ORDM) implementors are introduced to the ORDM product and the architecture of the ORDM data models and product stack. Tutorial text and diagrams introduce concepts and specific ORDM implementation procedures. Movies created with Macromedia Captivate provide interactive simulations of the tools used to customize ORDM.

The goal of this tutorial is to show you how to change preferences, and gather and publish statistics independently. Note: This OBE was tested on production software however some of the screenshots may still refer to the beta software.

The goal of this tutorial is to profile a data source, derive a data rule, and create a correction mapping to correct the data based on a similarity match. Note: The screenshots in this tutorial may appear slightly different from yours depending on the order in which you perform the other tutorials in this OBE Series. You can ignore the irrelevant items you see on your screens.

This tutorial shows you how you can use the Data Recovery Advisor to diagnose and repair data failures. Note: This OBE was tested on production software however some of the screenshots may still refer to the beta software.

This tutorial shows you how to use the Database Replay feature to perform real-world testing by capturing the actual database workload on the production system and replaying it on the test system. Note: This OBE was tested on production software however some of the screenshots may still refer to the beta software.

This tutorial describes how you can use the Enterprise Manager Database Control with its seven main pages to proactively and reactively monitor and manage your database environment. In addition, this tutorial describes how you can find a starting point for various database administration tasks, view your host configuration, tablespace contents, historical performance data, alert log errors, and the workflow to apply patches. Note: This OBE was tested on production software however some of the screenshots may still refer to the beta software.

This tutorial describes how to benefit from Automatic SQL Tuning to automatically tune your high loaded SQL statements. Note: This OBE was tested on production software however some of the screenshots may still refer to the beta software.

This demo provide information about package diagnostics using ADRCI

This demo shows how to migrate to ASM using Enterprise Manager