Course Search

Find A Masters

1000's of Masters Courses from across the globe

Find An MBA

MBA & Business Masters courses from the World's leading Business Schools

Find A PhD

The World's largest PhD opportunities database

Course Details

Oracle Data Integrator 11g: Data Warehousing Essentials

Like this CPDs ?

Like This Course?

Extra CPD Information

More Info

Location of CPD provider

Institution Location

Related CPDs

Related Courses

Getting the best out of your microscope - the essentials 2021
Royal Veterinary College
CPD Unit

Data Protection Training (A)
Onyx Support
CPD Courses

Data Protection Training (A)
Onyx Support
CPD Courses

Weblearning Network
CPD Courses
Available On Demand
120 Hours over 6 Months
Bespoke Course (Online)
ETL Developers, Application Developers, Data Warehouse Administrator, Data Warehouse Analyst, Data Warehouse Developer, BI Developer, Functional Implementer, Project Manager, Support Engineer
Online / Distance Learning Course

How This Course Is Organised

The Oracle Data Integrator 11g: Data Warehousing Essentials course provides step-by-step instructions on how to perform a variety of Oracle Data Warehousing and Integration and E-L-T (Extract, Load and Transformation) tasks using Oracle Database 11g and Data Integrator 11g for activities based on real-life work scenarios. 

You will learn how to plan, build and deploy a Data warehouse in an Oracle Database 11g environment using Oracle Data Integrator 11g as your primary ETL/ELT Tool for developing Extract, Transform and Load processes.

Using the graphical interfaces, you create and manage ODI repositories, which stores configuration information about the IT infrastructure, the metadata for all applications, projects, models and other ODI artifacts. You also learn how to create the ODI Topology, organize ODI models and design ODI interfaces, procedures, packages and other objects.

You will learn how to use Oracle Data Integrator Topology Manager to define context and logical schema objects according to current best practices. You will learn how to use manage projects in Oracle Data Integrator to develop interfaces and other objects.

You will learn how to create an integration process, using Oracle Data Integrator packages. This course takes you through some of the more advanced features and uses of Oracle Data Integrator interfaces. You will also learn how to use Operator to stop, start and track the execution of Oracle Data Integrator sessions.

The WebLearning hands-on series reduces the time spent investigating what steps are required to perform a task. Because the step-by-step solutions are built for practical real world situations, not only is knowledge gained through valuable hands-on experience, but also the solutions presented may then be used as the foundation for production implementation, dramatically reducing time to deployment.


Business Intelligence Developer
Data Warehouse Administrator
Data Warehouse Analyst
Data Warehouse Developer
Technical Administrator

Conceptual understanding of Databases and SQL

Course Objectives
Understand the ODI Data Warehouse and ETL Development Lifecycle
Understand the BI and Warehouse Development Process
Learn to Manange ODI 11g Warehouse Projects
Understand Data warehousing Concepts
Understand Dimension Modelling
Understand Oracle Database 11g warehouse Capabilities
Understand the Official Oracle Data warehouse Reference Architecture
Understand Data Quality Issues in ETL Process
Understand the architecture of the Oracle Data Integrator system
Define Data Sources
Define Physical and Logical Architecture
Create and reverse-engineer models
Create and Manage Projects
Define Integration Processes
Work with projects in Oracle Data Integrator and release your work for deployment
Understand models, reverse-engineering model metadata from your database
Manage metadata in Oracle Data Integrator: models and data quality
Create simple interfaces and add multiple sources to an interface
Enforce data quality constraints in an interface
Manage packages
Manage your ODI environment using the ODI Console

Course Topics

Course Scenario
ODI Value Proposition
Traditional ETL to Integration and Data Warehousing
Conventional ETL Design
The ELT Approach to Integration and Data Warehousing
Declarative Design
Traditional ETL versus E-LT Approach

Oracle Data Integrator Use-Case Scenarios
ELT for Data Warehouse and Business Intelligence
Service-Oriented Integration
Master Data Management

Oracle Data Integrator Architecture Overview
Graphical Interface
ODI Console
Exploring Oracle DI Console
Navigating Oracle DI Studio Interface

BI and Warehouse Architecture Framework
Data Sources
Data Access, Transformation, Cleansing
Staged Data
Business Subject Data
Multidimensional Data
Backup, Archive Data
Structured Query Language and OLAP Engine
Business Intelligence Applications
Administration, Automation, Operation, Control
Metadata Repository
Visualisation and Publishing

Data Warehousing and Modelling Concepts
Structured Modelling for Analytics and Data Warehouses
3rd normal Form
Dimensional Modelling
Fact tables
Types of Fact Tables
Dimension Tables
Star Schema
Snowflake Models
Constellation Models
Conformed Dimensions
Alternate Dimensions
Degenerate Dimensions
Junk Dimensions
Slowly Changing Dimensions
Surrogate keys

Data Warehousing Deployment Approaches
Warehouse Bus Architecture
Centralised Data Warehouse Approach
Hub and Spoke Approach

Introduction to Oracle Database11g
Oracle Database11g Options
Database Management Packs
Oracle Database11g Related Products

Data Warehouse Features of the Oracle Database
Partitioning and Partitioned Outer Join
Materialized Views and Windows Aggregate
Compression, Advanced Statistical Functions, SQL Model
Data Mining Model
OLAP Model

Understanding the Oracle Data Warehouse Reference Architecture
Components of the Reference Architecture
Data Sources
Staging Data Layer
Foundation Data Layer
Access and Performance Layer
Business Intelligence and Performance Management Tools
Linking insight to action with SOA
ETL, Messaging and Metadata
Data Loading Process
Information Provisioning Process

Oracle DI Studio Topology Concepts
Creating ODI Contexts

The Physical Architecture
The Logical Architecture
Logical Architecture and Contexts

Data Servers
Creating Physical Data Servers
Creating Logical Data Servers
Creating Physical Schemas
Creating Logical Schemas

Standalone and Java EE Agents
Physical and Logical Agents
Setting up Agents in an Oracle environment
Configure Physical Agents
Creating Logical Agents
Setting up Load Balancing

Knowledge Modules Concepts
Knowledge Modules at Design and Runtime
Pluggable Knowledge Modules
Importing Knowledge Modules
The Topology Matrix

Administrating the ODI Repositories
Connecting to ODI Master and Work Repositories
Creating Master Warehouse Repository
Connecting to the Master Repository
Creating Work Repository
Creating a Separate Master Repository for Production
Understanding the Impact of Work Repository IDs
Backing up Repositories

Approach to ODI Warehouse and ETL development
Strategy and Planning Phase
Discover Phase
Analyse Phase
Define Phase
Develop Phase
Deploy Phase

The BI and Warehouse Development Process
Identify People Involved
Identify business process requirements
The Data Warehouse and the Dimensional Model
Create and Study the enterprise business process list
Identify and Prioritise Business Processes
Identify high level entities and measures for conformance
Select requirements gathering approach
Requirements Gathering
Requirements Analysis
Identify the grain
Identify the dimensions
Identify the facts
Verify the model
Create Requirements Definition Document
Agree Requirements Definition document with the Users
Design and Build Warehouse and Reports
Physical Warehouse and Report design considerations
Acceptance Testing

Understanding the Extract, Transform and Integration Process
Data Extraction
The Logical Data Map
Building the Logical Data Map
Approach to Analysing ER Diagrams
Data Content Analysis
Collecting Business Rules in the ETL Process
Integrating Heterogeneous Data Sources
Challenge of Extracting from Disparate Platforms
Processing Fixed Length Flat Files
Processing Delimited Flat Files
Data Transformation
Data Capture

Managing ODI Data Warehouse Projects
Organising the ODI ETL Teams
Using Built-in Default Profiles
Reverse Engineering and Profiling Source Applications
Reverse Engineering an Oracle Schema
Understanding Oracle Data Integrator Interfaces
Mappings, Joins, Filters and Constraints
Approach to Implementing Interfaces
Designing and Implementing the Data Warehouse’s Schema
Specifying and Designing Business Rules
Building a Data Quality Framework
Packaging and Releasing Development
Versioning Development
Scheduling and Operating Scenarios
Monitoring the Data Quality of the Data Warehouse
Publishing Metadata to Business Users
Planning for Next Releases

Setting Up a New Project
Overview of Oracle Data Integrator Projects
Creating a New Project
Working with Folders
Working with Knowledge Module
Exporting and Importing

Working with Projects
Understanding the Project Life Cycle
Creating a Project
Working with Knowledge Modules

Project and Global Knowlegde Modules
Modules Naming Convention
Loading Knowledge Modules

Loading Customer Dimension
Creating the Customer Load Interface
Creating Customer Mappings
Creating Customer Filters
Creating Customer Data Flow
Executing the Customer Interface
Exploring the Quick Edit Editor

Loading City Dimension
Adding the City Dimension
Creating City Mappings
Creating City Data Flow
Executing the City Interface

Loading Products Dimension
Creating the Product Dimension Load Interface
Creating the Product Dimension Mappings
Creating the Product Dimension Data Flow
Executing the Product Dimension Interface

Loading Fact Tables
Creating Orders Fact
Editing Orders Fact Mappings
Creating Orders Fact Data Flow

Working with Data Integrity
Checking the Quality of Existing Data
Defining Reference Data Loading Rules
Defining Conditions to Enforce Data Load

Workflow Management
Working with Packages
Creating a Package
Exploring Package Tools
Linking Steps in Package
Creating Notification Message
Executing Package
Compile Package into Scenario

Working with Functions and Variables
Understanding User Functions
Creating a User Functions
Applying the User Function in an Interface
Run the User Function in the Interface
Creating a Variable

Working in Oracle DI Console
Testing a Data Server
Testing Physical Agent Connection
Adding a Data Server to a Physical Agent
Creating Templates for Physical Agents
Load Balancing Agents


This is a 6 Months course and Includes a Free eBook and six months access to a personal Tutor for support on-line.

Accrediting Bodies

Find CPD

Copyright ©2005-2021
All rights reserved

Find CPD is a database of Continuing Professional Development (CPD) Courses in the UK

FindCPD is a trading name of FindAUniversity Ltd.
FindAUniversity Ltd, 77 Sidney St, Sheffield, S1 4RG, UK. Tel: +44 (0)114 268 4940 Fax: +44 (0) 114 268 5766