ODI Training in Chennai

ODI Training in Chennai

Learn an advanced ETL cum ELT tool from experts in real-time to work on a live project or to leverage better opportunity in IT industry. Oracle Data Integrator provides a new declarative design(Interactive UI) approach to defining data transformation, integration and validation processes, resulting in faster(can handle huge data), simpler(Easy debugging) and cheaper(due to ELT, which is an exclusive part of ODI) development and maintenance of data warehousing.

Fill This Form For Demo Class

About Course

This course enables you to work in a real project implementing ODI (11g or 12c ) and how to build a 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. We guarantee that even a Non-ETL participant having very little knowledge of database can learn ODI.

Course objectives                             

At end of this ODI training by Htop, you will be able to,

  • Learn ODI architecture and how its different from other ETL tools
  • Build master and Work Repositories.
  • Create Agent(ODI’s execution engine) and how to configure the agent to meet optimization.
  • Create different objects like Packages, Interface (Mapping), procedure, Models and variables to design a data transformation workflow.
  • Learn how to handle Exceptions in workflow through the 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 the 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 can learn this course?

ODI can be learned by anyone who wants to make his carrier in Data science as Data analyst.This training will be suitable for

  • Fresh Graduates
  • College / School Students
  • Job Seekers
  • Data Scientist works in ETL and reporting tool
  • Who are having good knowledge in Java

Job Opportunity

Many companies are now moving from other ETLs like Informatica, Datastage, Abnitio to ODI because of its capability of handling huge data in a faster and cost-effective manner. After this training, you will surely be able to handle interviews questions and can work on any live project implementing ODI.

Course Duration Information

This ODI training will happen for 25 hours. If you opt for weekend classes both Saturday and Sunday you will be having approximately 2 hours 30 mins in scheduled time of the batch you chose. If you opt for weekdays classes all Monday to Friday you need to spend at-least 90mins.

Course Syllabus

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 insecurity
  • 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 Flexfields for objects

ODI Variables, functions and procedures

  • Types of variables
  • Use cases of variables in workflow
  • 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
  • A 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
  • Partitioning
  • Generating DDL scripts and Interface IN/OUT

Data Quality Control

  • Check Constraints
  • 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 workflow
  • 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 the package
  • Introduction to Load plans
  • Serial and parallel session execution in Load plans
  • Flow control and exceptional handling of Load plans

ODI Designer

  • Project and its components
  • Cross-references of objects in the designer navigator
  • Knowledge module Import
  • Markers and Memos
  • The 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
  • Datamart
  • Dimension and Facts
  • Star and snowflake schemas

Slowly Changing Dimension (SCD)

  • SCD overview
  • SCD type 1,2 and 3
  • SCD implementation of 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 workaround)
  • Expression
  • Datasets
  • 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 a 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 of 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

Good place to learn selenium. Found them online and joined classroom training. Trainers are experienced working professionals, explained all syllabus and nice environment to learn

Gayathri Kumar

Selenium Training, Working in CTS

Our Trending Courses

× Hi..!! Ping Me

Fill this form for call back