OVERVIEW
Oracle Warehouse Builder (OWB) Release 10ginstructs 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.
DURATION: 3 Days
OBJECTIVES
- Review the installation of OWB and the installation requirements.
- Define how to use OWB as your main ETL toolset.
- Define the different mappings needed for importing data.
- Understand the deployment of code to Oracle.
- Apply practical use of OWB by implementing them in hands-on lab.
- Provide best practices guidelines for using OWB.
- Facilitate discussion of student questions about the concepts and implementation of OWB.
PREREQUISITES
Persons taking this class should have a basic understand of Entity Relationship Modeling (ERD) and relational design concepts, SQL and PL/SQL programming and Data Warehousing concepts. These classes are offered by ONYX.
INTENDED AUDIENCE
Developers responsible for extract, transform and load processes using OWB.
FORMAT
Lecture and discussion followed by hands-on lab workshops for each major topic to reinforce the material. Each participant will receive an extensive lecture guide with several examples and workshop solutions.
CONTENT
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
- Review the installation and setup of the product
- Review the database used for the hands-on labs
- How to logon
- 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
- Details how to use different operators in a mapping to transform data
- Using joins within the mappings
- Transformations
- How to import, create, and use transformations in mappings
- Understanding the driver stored procedures
- Understand how error handling can be built into stored procedures
- Configuring ETL Objects
- Describes how to configure mappings and process flows for deployment to a specific database instance
- Deploying and Executing
- Deploying the objects you have defined and executing the processes
- Validating Objects
- How to verify the integrity of the objects
- Deploying Target Systems
- How to deploy the physical instance of your target data system
- Auditing Deployment and Execution
- Warehouse Builder’s web-based Runtime Audit Browser