Description

Type

Training
Level

Beginner
Methodology

Online
Duration

1 Month
Start date

Different dates available

Online campus

Yes
Delivery of study materials

Yes
Support service

Yes
Virtual classes

Yes

Learn concepts of Oracle Warehouse Builder 11g.
This training starts you at the beginner level and concludes with knowledge of advanced concepts and end-to-end implementation of data integration and ETL through Oracle Warehouse Builder.

Facilities

Online

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

All
Students
Centre

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

Design
Builder
Warehouse
Licensing
Oracle
Oracle Fusion
Oracle Database
Oracle Certification
OS
Operating Systems
Targets
Oracle Warehouse
OWBSYS

Course programme

COURSE DETAILS & CURRICULUM

Installing and Setting Up the Warehouse Builder Environment

Oracle Warehouse Builder Licensing and Connectivity Options
Supported operating systems (OS), sources, targets, and optional components
What Is Oracle Warehouse Builder?
Using the Repository Assistant to Manage Workspaces
OWBSYS Schema
Using OWB 11.2 with Database 10g R2
Installing Oracle Warehouse Builder 11.2
Basic Process Flow of Design and Deployment

Getting Started with Warehouse Builder

Locations Navigator and Global Navigator panels
Logging In to OWB Design Center
Overview of Objects within a Project
Setting Projects Preferences: Recent Logons
OWB Projects
Overview of the Design Center
Organizing Metadata Using Foldering
Overview of Objects within an Oracle Module

Understanding the Warehouse Builder Architecture

Overview of Configurations, Control Centers, and Locations
Warehouse Builder Development Cycle
Registering an Oracle Workflow User
Registering DB User as an OWB User
Roles and Privileges of Warehouse Builder Users
Creating Target Schemas
Overview of the Architecture for Design, Deployment, Execution

Defining Source Metadata

Difference Between Obtaining Relational and Flat File Source Metadata
Data warehouse implementation: Typical steps
Creating an Oracle Module
Sampling Simple Delimited File
Creating Flat File Module
Sampling Multi-record Flat File
Selecting the Tables for Import

Defining ETL Mappings for Staging Data

Mapping Editor Interface: Grouping, Ungrouping, and Spotlighting
Creating External Tables
Purpose of a Staging Area
Set loading type and target load ordering
Define OWB Mappings
Levels of Synchronizing Changes
Using the Automapper in the Mapping Editor
Create and Bind process

Using the Data Transformation Operators

Lookup Operator: Handling Multiple Match Rows
Component Palette
Using the Aggregator, Constant, Transformation, and Pre/Post Mapping Operators
Pivot and Unpivot Operators
Using the Set, Sequence, and Splitter Operators
Using the Subquery Filter Operator
Using a Joiner
Deploying and Executing in Projects Navigator Panel

Cleansing and Match-Merging Name and Address Data

Name and Address Data Cleansing
Using the Match Merge Operator in a Mapping
Name and Address Software Providers
Reviewing a Name and Address Mapping
Settings in the Name and Address Operator
Consolidating Data Using the Match Merge Operator
Name and Address Server
Integrating Data Quality into ETL

Using Process Flows

Types of Activities: Fork, And, Mapping, End Activity
Creating Transitions Between Activities
Some More Activities: Manual, SQLPLUS, Email
Process Flow Concepts
Creating a Process Flow Module, a Process Flow Package and a Process Flow
Generating the Process Flow Package

Deploying and Reporting on ETL Jobs

Deployment Concepts
Repository Browser
Starting OWB Browser Listener and the Repository Browser
Browsing Design Center and Control Center Reports
Setting Object Configuration
Logical Versus Physical Implementation
Invoking the Control Center Manager
Deploy Options and Preferences

Using the Mapping Debugger

Preparing the testing environment and test data
Overview of the Mapping Debugger
Initializing a Mapping Debugging Session
Evaluating the flow of data to detect mapping errors
Setting breakpoints and watch points

Enhancing ETL Performance

Performance-Related Parameters in ETL Design
Configuring Indexes, Partitions, Constraints
Setting Tablespace Properties and Gathering Schema Statistics
Configuring Mappings for Operating Modes, DML Error Logging, Commit Control, and Default Audit Levels
Enabling Partition Exchange Loading (PEL) for Targets
Enabling Parallelism and Parallel DML
Performance-Related Parameters in Schema Design
Performance Tuning at Various Levels

Managing Backups, Development Changes, and Security

Overview of Metadata Loader Utilities (MDL)
Graphical UI for Security Management
Managing Metadata Changes by Using Snapshots
Object-Level Security
Using Change Manager
Version Management of Design Objects
Setting Security Parameters

Integrating with Oracle Business Intelligence Enterprise Edition (OBI EE)

Converting the UDML File for OBI EE
Oracle BI Admin and Answers Tool
Integrating with OBI EE and OBI SE
Business Justification: Tools Integration
Deploying the BI Module
Transferring BI Metadata to OBI EE Server
Setting Up the UDML File Location
Deriving the BI Metadata (OBI EE)

Administrative Tasks in Warehouse Builder

Multiple Named Configurations: Why and How
Enterprise ETL License Extends Core In-Database ETL
Creating an OWB Schedule
Using Configuration Templates
Using Multiple Named Configurations
Steps for Setting Up OWB in a RAC Environment

Managing Metadata

Using Pluggable Mappings
Advanced Activity Types in Process Flows
Using the Change Propagation Dialog
User-Defined Properties, Icons, and Objects
Invoking Lineage and Impact Analysis
Using Lineage and Impact Analysis Diagrams
Heterogeneous Predefined SQL Transformations
Native Relational Object Support

Accessing Non-Oracle Sources

Defining New Integration Platforms in OWB
Location of Seeded Code Templates
Extensible Framework of OWB 11g Release 2
Benefits of Extensible Code Templates
Creating New Code Templates

Designing Mappings with the Oracle Data Integration Enterprise Edition License

Convert a Classic Mapping to a CT Mapping That Utilizes Data Pump
Execution View Versus Logical View
Traditional Versus Code Template (CT) Mappings
Assigning a Code Template to an Execution Unit
Execution Units in a CT Mapping
CT Mappings Deploy to Control Center Agents

Right-Time Data Warehousing with OWB

Starting CDC Capture Process
What Refresh Frequency Does OWB Support
Building a Trickle Feed Mapping
What Is Meant by Real-Time Data Warehousing
Using Advanced Queues in Trickle Feed Mappings
Using CDC Code Templates in Mappings for Change Data Capture

Defining Relational Models

Defining a Cube
Using the Create Time Dimension Wizard
Binding Dimension Attributes to the Implementation Table
Defining Dimensions Using Wizards and Editors
Specifying a Cube's Attributes and Measures
Designing Mappings Using Relational Dimensions and Cubes
Defining Dimension Attributes, Levels, and Hierarchies

More Relational Dimensional Modeling

Initial Versus Incremental Data Warehouse Loads
Capturing Changed Data for Refresh
Creating a Type 2 Slowly Changing Dimension
Updating Data and Metadata
Choosing the DML Load Type
Support for Cube-Organized Materialized Views
How OWB Manages Orphans
Setting Loading Properties

Modeling Multidimensional OLAP Dimensions and Cubes

Dimensional Modeling Using OWB
Multidimensional Data Types
What Is OLAP
OWB Calculated Measures
Analytic Workspace

See related categories

Contact us

DATA INTEGRATION WITH ORACLE WAREHOUSE BUILDER

Questions & Answers

Reviews

Subjects

Course programme

Add similar courses
and compare them to help you choose.

DATA INTEGRATION WITH ORACLE WAREHOUSE BUILDER

Questions & Answers

Reviews

Subjects

Course programme

Add similar coursesand compare them to help you choose.

Add similar courses
and compare them to help you choose.