About Oracle Data Integrator

This course enables you to work in real project implementing ODI (11g or 12c ) and how to build data warehouse using different modules of ODI, how to transform and validate data from one form to another (files, XML, database etc). We customized this course curriculum to meet the current industry standards.

Course Objective:

At end of this training you will be able to:
 Learn ODI architecture and how it’s different from other ETL tools
 Build master and Work repositories.
 Create Agent (ODI’s execution engine) and how to configure agent to meet optimization.
 Create different objects like Packages, Interface (Mapping), procedure, Models and variables to design a data transformation work flow.
 Learn how to handle Exceptions in work flow through customizable code and through rich ODI components like Load plans.
 Customize view of ODI repositories for every user through its Security architecture.
 How to implement physical and logical architecture and migrate the logical code from development to production environment.
 Implementation of KMs for different technology and how to customize your own KM to meet complex requirement.
 Reverse Engineer metadata in ODI for different technology like RDBMS, Files, XML, excel etc.
 Code optimization techniques to speed up the overall batch process and learns how ODI excels it.
 Using customize java APIs in different objects of ODI to make code environment independent.
 Implementation of CDC and SCD in ODI.
 Learn new features provided in latest 12c version and how it integrates more advanced technology like Big data.

Who should do this course?

ODI can be learnt by anyone who wants to make his career in Data science as Data analyst .This training will be suitable for:
 Fresh Graduates
 Data Scientist works in ETL and reporting tool
 Who are having good knowledge in Java


Basic knowledge in SQL is must

Course Content

Oracle Data Integrator Overview

Traditional ETL vs ODI ELT

Business use cases

ODI Architecture

Installation overview

ODI Repositories And Agents

Creating Master and Work repositories

Administering repositories

Introduction to Repositories Metadata (SNP tables)

Agents and its configuration (Standalone Agent)

ODI Security and Topology

Custom profiles in security

Creating users with generic and non-generic profiles

Topology Configuration

Defining any new technology in Topology

Logical and Physical architecture

Setting data server and physical schema

Context and Agents

Defining Flex fields for objects

ODI Variables, functions and procedures

Types of variables

Use cases of variables in work flow

User defined Functions

Native and user defined sequences

ODI procedures

Global objects (variable, functions, procedures, sequences and KMs)

Knowledge Modules

Six different Types of knowledge Modules

Knowledge module customization w.r.t. to business use cases

Technology specific KMs

Brief discussion of KM options and tasks

Introduction to java APIs and their use cases inside KMs.

Creating your own customized KM

Multi connection KM

Models and Constraints

Introduction to Models and Datastore

Defining ODI model w.r.t. Technology

Model creation through Common format designer

Reverse Engineering

Defining Datastore

ODI specific constraints on Datastore


Generating DDL scripts and Interface IN/OUT

Data Quality Control

Check Contraints

Static and Flow control

Recycle errors

Metadata tables for error diagnostics (SNP tables)


Defining Staging Area

Use cases for defining staging area w.r.t. technology

ODI Operator

Monitoring Integration process

Debugging integration Session and tasks

Restart mechanism

ODI job scheduling

ODI logs and log purge

Packages, Load plans and Scenarios

Introduction to package work flow

Synchronous and Asynchronous Run

Creating Scenarios for objects

Dynamic value binding in Scenarios

Business use cases for defining flow and scripting

Defining sequence of steps and running a package or scenario

Exception handling inside package

Introduction to Load plans

Serial and parallel session execution in Load plans

Flow control and exceptional handling in Load plans

ODI Designer

Project and its components

Cross – references of objects in designer navigator

Knowledge module Import

Markers and Memos

Scope of variables and other objects

Change Data capture (CDC)

CDC overview and implementation

Static and consistent CDC

Trigger based CDC

Golden gate CDC

Timestamp based CDC

Journalizing Knowledge module (JKM)

Data warehousing

Data warehousing basics and overview


Dimension and Facts

Star and snowflake schemas

Slowly changing Dimension (SCD)

SCD overview

SCD type 1, 2 and 3

SCD implementation inside Models

Knowledge Module customization for SCD

Integration of dimension and facts table (end to end cycle)

Interface (Mapping)

Navigation and mapping editor

Mapping creation with multiple targets 12c

Defining LKM, IKM and CKM inside mapping

Implementation of business logic inside mapping

Defining datasets and lookups

Physical and Logical mapping (12c)

Defining options inside KM

Temporary Interface (11g)

Reusable mapping (12c)

Data warehousing implementation using reusable mapping

Designing ETL vs ELT mapping

ODI components

Overview and implementation

Joins and filters

Aggregation (not available in 11g and its work around)





Split and sort

Lookup and Distinct

Code Migration

Different techniques for code migration

Smart import and Export

Unique internal Ids and GUID

Unique repositories IDs

Export and Import Hierarchy

Setting up production environment

Working with Different Technologies

File and table transformations

XML transformations

Working with delimited and fixed file format

Version Controlling

Version controlling

Implementation versions in Solutions

Maintain versions with metadata

External code backup

ODI Tools Reference

Tools guide

Different file Tools

Object related tools

Execution tools

Tool Customization

ODI through Web Services

Introduction to ODI web services

J2EE agent and its advantage

Data services

ODI console

Invoking third party web services

Managing Executions using web services

ODI Performance Tuning

Mapping optimization (data movement reduction)

Runtime optimization (Agent location)

Load balancing

Mapping loading stratagies.


Integration of Big data and hadoop in ODI

Integration with Nosql databases

Implementing Jython code in ODI procedures

Knowledge Module customization complex use cases

Implementation of Java Grovvy within ODI

Call Now- +91-921-276-0556

Send a Query

Tai Infotech Pvt Ltd, 2017 All Rights Reserved