BECOME A Alteryx EXPERT

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
Type
Course Duration
Price
ODI
Training
40 hrs
18,000/-
ODI
Workshop
ODI
Training & Workshop

ODI Course Content

Introduction

  • 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

Repositories

  • 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

ODI Topology Concepts/Physical and Logical Architecture

  • 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

Setting Up a New ODI Project

  • 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

Oracle Data Integrator Model Concepts

  • What is a Model?
  • Creating Models
  • Organizing Models
  • Understanding Metadata in ODI
  • Understanding Reverse Engineering
  • Difference Between Standard and Customized Reverse Engineering

Agent

  • What is Agent
  • Agent Configuration
  • Agent Test with Basic Mapping

Organizing ODI Models And Creating Data Sources

  • 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 and Debugging and Logging Details

  • 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

Various Options in ODI TOOL - Part 1

  • Find ODI Object
  • Disconnect
  • Repository Connection Information
  • Change ODI User password
  • Switch Password Storage
  • Locked Objects
  • Version Browser
  • Manage Libraries
  • HTTP Analyzer

Various Options in ODI TOOL - Part 2

  • Import
  • Export
  • Generate Reports
  • Hide Unused Technologies
  • Purge Log
  • Clean Stale Session
  • Remove Temporary Objects
  • Default Designer Context
  • Password Policies

Designing Mappings: Advanced Topics

  • Creating and Tracking Variables
  • Creating User Functions
  • Mapping Substitution Methods
  • Modifying a KM
  • Showing Variable Values in Log

Creating and Running ODI procedures

  • What is a Procedure?
  • Examples of Procedures
  • Creating Procedures
  • Adding Commands
  • Adding Options
  • Running a Procedure
  • Viewing Results with Operator

Creating and Running ODI Packages

  • What is a Package?
  • Creating a Package
  • Executing a Package
  • Creating Advanced Packages
  • Error Handling
  • Using the Advanced tab

Managing ODI Scenarios and Versions

  • 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

Enforcing Data Quality and Auditing Data with ODI

  • 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

Working with Changed Data Capture

  • 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