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: E-L-T/ETL Development Fundamentals

Like this CPDs ?

Like This Course?

Extra CPD Information

More Info

Location of CPD provider

Institution Location

Related CPDs

Related Courses

Fundamentals of Epidemiology
University of Manchester
Faculty of Biology, Medicine and Health

Fundamentals Of Public Relations (PR01)
London School of Public Relations
CPD Courses

Fundamentals Of Public Relations (PR01)
London School of Public Relations
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: E-L-T/ETL Development Fundamentals course provides step-by-step instructions on how to perform a variety of Data Integration and E-L-T (Extract, Load and Transformation) tasks using Data Integrator 11g for activities based on real-life work scenarios. 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, organise 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 also learn about the types of metadata, and how to retrieve it automatically from your database.
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.
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 ETL Development Lifecycle
Understand basic Data warehousing Concepts
Understand basic Dimension Modelling
Understand Data Quality Issues in ETL Process
Understand the architecture of the complete Oracle Data Integrator system
Define Data Sources
Define Physical and Logical Architecture
Create and reverse-engineer models
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
Launch a session to run an interface
Enforce data quality constraints in an interface
Manage packages


Course Topics:

Course Scenario
Understanding ETL and Data Integration Platforms
ETL Framework and Components
The Evolution of ETL
Code Generators versus Engines
Database-Centric ETL

Data Integration Platforms
ETL versus EAI
Understanding the Data Integration Tool Market
Functional Capabilities of Data Integration Tools

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

Introduction to ETL Development
The Planning and Design Thread
The Data Flow Thread
Data Delivery Thread

ETL Data Structures
ETL and Data Staging
Designing the Staging Area
Data Structures in the ETL System
Flat Files
XML Data Sets
DTDs, XML Schemas, and XSLT
Relational Tables
Independent DBMS Working Tables
Third Normal Form Entity /Relation Models
Non-relational Data Sources
Dimensional Data Models
Fact Tables
Dimension Tables
Atomic and Aggregate Fact Tables
Surrogate Key Mapping Tables
Impact Analysis
Metadata Capture
Naming Conventions
Auditing Data Transformation Steps

Oracle ETL-ELT Reference Architecture
Information Architecture Capabilities
Information Provisioning
Data Processing
Data Governance
Data Virtualisation
Information Delivery
Information Access
Information Modelling

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

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

Cleansing and Conforming
Data Cleansing Techniques
Data Conditioning
Data Integration
Data Refining

Data Quality Assessment
Anomalies in Data Fields
Lack of Data Standards
Lack of Data Consolidation

Introduction to Oracle Data Integrator
Oracle Data Integrator Product Architecture
Knowledge Modules
Data Quality
Data Integrity
Name and Address Cleansing Tools
Changed Data Capture
Oracle Data Integrator and Oracle SOA Suite
Oracle Data Integrator in Relation to Oracle Warehouse Builder

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

ODI Topology Concepts
The Physical Architecture
The Logical Architecture
Logical Architecture and Contexts
Data Servers

Standalone and Java EE Agents
Physical and Logical Agents
Configure Physical Agents
Creating Logical Agents
Setting up Load Balancing

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

Working with Contexts
Creating Developer Context
Creating Production Context

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

Extracting, Transforming and Loading Customer Dimension
Creating the Customer Load Interface
Creating Customer Mappings
Creating Customer Filters
Creating Customer Data Flow
Executing the Customer Interface

Extracting, Transforming and Loading City Dimension
Adding the City Dimension
Creating City Mappings
Creating City Data Flow
Executing the City Interface

Extracting, Transforming and Loading Heterogeneous Sources
Adding Heterogeneous Sources
Creating Heterogeneous Joins
Creating Heterogeneous Mappings
Exploring the Heterogeneous Data Flow
Executing the Heterogeneous Interface

Extracting, Transforming and Loading Fact Tables
Creating Orders Fact
Editing Orders Fact Mappings
Creating Orders Fact Data Flow

Extracting, Transforming and Loading XML Files
Creating the XML Load Interface
Creating the XML Joins
Creating the XML Mappings
Creating the XML Data Flows
Executing the XML Interface

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


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