Oracle Warehouse Builder 10g Administration
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
|
Schedule/Purchase
|
Training Formats
|
Price
|
Duration
|
|
View Schedule(Link)
|
Instructor-Led Training
|
SAR 7031.25
|
3 Days
|
Audience:
- Database Administrators
- Functional Implementer
- Data Warehouse Administrator
- Project Manager
Prerequisites:
Required Prerequisites:
- Experience in basic use of Oracle RDBMS, including SQL DDL and DML, and PL/SQL
Suggested Prerequisites:
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
|
