ExtraCourse is the No.1 ODI online training institute offering ODI online and classroom courses in Hyderabad with expert guidance and 100% placement assistance..

Extra Course is the best ODI training institute in Hyderabad. We offer 100% practical driven program through our unique experimental learning, focus on a comprehensive practical approach. We follow a holistic curriculum which has been designed by Industrial experts in a systematic approach from the beginner’s level to a more advanced study.

Holistic Curriculum | Complete Practical Driven Learning | Real-Time Projects | Be a Future Ready

Key Highlights ODI online trainings

  • Curriculum is curated by Industrial Experts in ODI
  • Extensive study on real time projects
  • Handouts, Exercises and Assignments on each and every topic in ODI
  • Work on Real-time scenarios
  • 100+ Hands on Practical Assignments
  • Real time work on currently running projects
  • Resume preparation
  • Mock Interviews
  • 100% Placement Assistance
  • All classes will be recorded and sent to you everyday
  • Get Certified
Who We are

What you'll learn

1.Administer ODI resources and setup security with ODI
2.Apply ODI Topology concepts for data integration
3.Describe ODI Model concepts
4.Describe architecture of Oracle Data Integrator 12c
5.Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations
6.Explore, audit data, and enforce data quality with ODI
7.Implement Changed Data Capture with ODI

Course Duration

Course Name
Course Duration
40 hrs
Training & Workshop

ODI Course Content

  • What is Oracle Data Integrator?
  • Why Oracle Data Integrator / Advantages of ODI Tool Over Other ETL Tools
  • ETL vs ELT Architecture
  • Overview of ODI Architecture
  • Overview of ODI Components
  • About Graphical Modules
  • Overview of Oracle Data Integrator Repositories
  • Types Of Repositories and Repository Creation Process
  • Creating and Connecting to the Master Repository
  • Creating and Connecting to the Work Repository
  • Dev vs Execution Work Repository
  • Viewing Connection Information
  • RCU Method of Repository Creation
  • Real time Best Practice for Repository Creation
  • Overview of ODI Topology
  • Data Server and creation of Data Server
  • Testing Data Server Connection
  • Physical Schema
  • Work Schema
  • Defining the Physical Architecture
  • Defining the Logical Architecture
  • Mapping Logical and Physical Resources
  • Contex
  • Overview of ODI Projects
  • Creating a New Project
  • Creating and Maintaining Folders
  • Organizing Projects and Folders
  • Understanding Knowledge Modules
  • Exchanging ODI Objects and Sharing Global Objects
  • What is a Model?
  • Creating Models
  • Organizing Models
  • Understanding Metadata in ODI
  • Understanding Reverse Engineering
  • Difference Between Standard and Customized Reverse Engineering
  • What is Agent
  • Agent Configuration
  • Agent Test with Basic Mapping
  • What is a Mapping?
  • Business Rules for Mappings
  • Creating a Basic Mapping
  • Creating Join
  • Data Filter?
  • SET Component
  • Aggregate Component
  • Distinct Component
  • Router Activity
  • What is a Constraint?
  • Staging Area and its significance
  • Selecting Knowledge Module
  • Different Types Of Knowledge Module
  • Mapping with Knowledge Modules (KM)
  • Creating an Mapping With Knowledge Module
  • Monitoring Mappings
  • Creating Objects with Operator
  • Viewing Sessions and Tasks
  • How to Monitor Execution of a Mapping
  • How to Troubleshoot a Session
  • Keys to Reviewing the Generated Code
  • Working with Errors
  • Markers
  • Configuring Constraint in ODI
  • Find ODI Object
  • Disconnect
  • Repository Connection Information
  • Change ODI User password
  • Switch Password Storage
  • Locked Objects
  • Version Browser
  • Manage Libraries
  • HTTP Analyzer
  • Import
  • Export
  • Generate Reports
  • Hide Unused Technologies
  • Purge Log
  • Clean Stale Session
  • Remove Temporary Objects
  • Default Designer Context
  • Password Policies
  • Creating and Tracking Variables
  • Creating User Functions
  • Mapping Substitution Methods
  • Modifying a KM
  • Showing Variable Values in Log
  • What is a Procedure?
  • Examples of Procedures
  • Creating Procedures
  • Adding Commands
  • Adding Options
  • Running a Procedure
  • Viewing Results with Operator
  • What is a Package?
  • Creating a Package
  • Executing a Package
  • Creating Advanced Packages
  • Error Handling
  • Using the Advanced tab
  • What is a Scenario?
  • Managing Scenarios with Load Plans
  • Preparing Scenarios for Deployment
  • Automating Scenario Management
  • Scheduling the ODI Scenario
  • Overview of ODI version management
  • Handling concurrent changes
  • Why Data Quality?
  • When to Enforce Data Quality?
  • Data Quality in Source Applications
  • Data Quality Control in the Integration Process
  • Data Quality in the Target Applications
  • Enforcing Data Quality
  • Exploring Your Data
  • Auditing Data Quality
  • Overview of ODI version management
  • Techniques of Changed Data Capture
  • Changed Data Capture in ODI
  • CDC Strategies and Infrastructure
  • CDC Consistency
  • Creating Change Data Capture (CDC)
  • Viewing Data/Changed data and Journalizing