Oracle Warehouse Builder 10g: Administration

 Oracle University provides a downloadable eKit containing the training materials for this course.

What you will learn:

This hands-on course addresses specific administration features available in Oracle Warehouse builder 10g Release 2 (OWB). The course covers the administration tasks that may be performed during a data warehouse development process and also the administration tasks that are performed to maintain a fast and efficient Warehouse Builder system.

Students will learn strategies of administering an OWB environment. The course discusses strategies on how to configure and manage repositories, on backup and recovery, on how to manage the Control Center service, utilizing Real Application Clusters and more. Guided lab practices will give the students a hands-on opportunity to learn the administrative functionalities of OWB. This course is targeted for OWB administrators; not Warehouse Builder ETL programmers.

Learn to:

• Diagnose and debug errors (not mapping debugging)
• Apply performance enhancement methods
• Install and setup OWB in a RAC environment
• Manage OWB security
• Configure OWB for a multi-user environment
• Manage configuration and runtime settings

Note:

The current version of this course is presented using OWB 10gR2, however this course is also suitable for OWB 11gR1 customers. The user interface differences between OWB 10gR2 and 11gR1 are very minor and hence are not included in this course's lab practices.

Schedule/Purchase	Training Formats	Price	Duration	Course Materials	Instruction Language
View Schedule	Instructor-Led Training	US$ 1,800	3 Days	English	English

 

Note: To have a more personalized experience, we invite you to: Log In!

Audience:

• Data Warehouse Administrator
• Database Administrators
• Functional Implementer
• Project Manager

Prerequisites:

Required Prerequisites:

• Experience in basic use of Oracle RDBMS, including SQL DDL and DML, and PL/SQL

Suggested Prerequisites:

• OTN Oracle By Example (OBE): Introduction to OWB 10g Rel. 2
• Prior hands-on experience using an earlier version of OWB
• Oracle Warehouse Builder 10g: Implementation Part I

Course Objectives:

• Demonstrate how to administer using OMB Plus commands and SQL scripts
• Demonstrate how to troubleshoot common errors
• Describe how OWB works in a RAC environment
• Understand Warehouse Builder Architecture and Components
• Describe Configuration and Runtime Management features
• Demonstrate Backup and Upgrade methodology
• Describe security and metadata management functionality
• Describe performance enhancements methods

Course Topics:

Components of OWB Architecture

• Design Center client interface
• Unified repository
• Control Center and Control Center service
• Installation requirements
• Implementing a remote runtime

Preparing the Infrastructure

• Configuring client, server, and database machines
• Installing and Configuring Workflow
• Installing and Configuring the Repository
• Defining Repository owner and user(s)
• Managing Control Centers and Locations
• Managing Configurations

Configuration and Runtime Management

• Multi-configuration concepts
• Version management (Collections)
• Applying Multi-configuration and version management to DEV-QA-Prod scenario
• Runtime Platform Configuration
• Preferences and settings for runtime
• Runtime views and utilities
• Public Views

Backup and Upgrade Strategies

• Metadata Loader utilities
• Database backups
• Supporting upgrade from earlier OWB Releases
• Patching Warehouse Builder
• Time dimension changes
• Managing Metadata changes-- through Snapshots

Security and Metadata Management

• Applying security roles and privileges
• Setting security policy for the repository
• Metadata Security strategies
• Enforcing Security Policies
• Manage security in a multiple-user environment
• Public repository objects
• Enabling Security aspects of some Process Flow Editor activity types
• Configuring Repository Browser environment

Performance Enhancement Methods

• Configuring tablespaces, parallelism, PDML
• Moving large volumes of data through Transportable Tablespaces
• Scheduling ETL objects using Oracle Enterprise Manager or DB Scheduler
• Multiple CPUs and Parallelism
• Gathering Statistics
• Setting properties for performance tuning

Diagnosing and Debugging

• Using OMB administrative commands
• Using OWB_HOME SQL scripts
• Analyzing log files
• Known errors and their solutions

Warehouse Builder in RAC Environment

• Installing OWB into a RAC environment
• Specific RAC parameters on the OWB and database sides
• Monitoring and troubleshooting RAC nodes

Suggested Next Courses:

• Oracle Database 10g: Implement and Administer a Data Warehouse