Oracle Warehouse Builder I Training Class- ORA405
Oracle Warehouse Builder (OWB) Release 10g instructs students in the use of the OWB toolset, to extract, transform and load data. This course will include an overview of the data warehousing principles. The OWB topics covered will include defining, configuring, and validating the physical instance of the data warehouse. We shall cover generating, and deploying scripts to load the data warehouse from various sources.
Oracle Warehouse Builder I Training Class – ORA405 Request a Class Date
Oracle Warehouse Builder (OWB) Release 10g instructs students in the use of the OWB toolset, to extract, transform and load data. This course will include an overview of the data warehousing principles. The OWB topics covered will include defining, configuring, and validating the physical instance of the data warehouse. We shall cover generating, and deploying scripts to load the data warehouse from various sources.
Course ID: ORA405
Duration: 3 days
Audience: Developers responsible for extract, transform and load processes using OWB.
Topics covered in The Oracle Warehouse Builder I Course:
Intro to Data Warehousing
- What is a Data Warehouse?
- The Star Schema
- Star Schema Design
- The Snowflake Schema
- Snowflake Schema Design
- Star vs. Snowflake Schema
- Architecture Decisions
- Required Database Features
- Software Configurations
- Building a Dimensional Data Warehouse
Fact Tables
- Event tracking tables
- Dimension tables
- Database sizing
- Indexing issues
- Aggregation strategies
- Historical duration consideration
- OWB Overview
Describes the overall product
- Installation and setup review
- Review the labs database
- Logging on
- The Main console
- Preferences
- Getting Started with Warehouse Builder
- How to start building projects
- OWB Features
Defining Source and Target Objects
- Creating and configuring the metadata definitions
- Defining Oracle Data Objects
- Create definitions for relational and dimensional target objects
- Importing Data Definitions
- Import definitions for data sources
- Configuring Data Objects
- Assign physical properties
- Create and design mappings
- Using Mapping Operators
- Transforming data with operator mapping
- Using joins within the mappings
- Transformations
Import, create, and use transformations in mappings
- Understanding the driver stored procedures
- Error handling and stored procedures
- Configuring ETL Objects
- Configure mappings and process flows for deployment
- Deploying and Executing
- Deploying the objects and executing the processes
- Validating Objects
- Verifying the integrity of the objects
- Deploying Target Systems
- Deploying the physical instance of target data system
- Auditing Deployment and Execution
- Warehouse Builder’s Runtime Audit Browser