ORACLE ODI

We offering Oracle ODI online training USA quite a lot of features. Our faculty has Real Time experience in IT industry. We offer Best Oracle ODI Online Training at your comfortable timings from your home with flexible schedules. Student can select regular fast track and weekend Oracle ODI Classes. Each trainer regularly assessed to candidates given the best quality of Oracle ODI in Online Training. Demos are conducted by every day and you can choose flexible timings according to your requirement.

We provide free demo on Oracle ODI Online Training Classes and course materials an in-depth knowledge of Oracle ODI which focuses on real time scenarios. Recorded sessions are provided after each class. We arrange regular and weekend Oracle ODI Training for employees and students. Resume build as per corporate standards according to the job description and we will market your resume for top companies. We provide Oracle ODI Online Training and project support across the World like USA, UK, South Africa, Malaysia, Singapore, Australia and Japan.

Oracle ODI Online Training Course Content

Introduction to Integration and Administration

  • Oracle Data Integrator: Introduction
  • Why Oracle Data Integrator?
  • Conventional Integration Process: ETL
  • ELT
  • ODI Architecture
  • ODI Components
  • ODI Repositories
  • Master and Work Repositories

Administering ODI Repositories

  • Administering ODI Repositories
  • Steps to Set Up ODI Repositories
  • Creating the Master Repository
  • Connecting to the Master Repository
  • Creating a Work Repository
  • Connecting to the Work Repository

ODI Topology Concepts

  • ODI Topology Concepts
  • ODI Topology: Overview
  • What Is Topology?
  • Data Servers and Physical Schema
  • What Is a Data Server?
  • What Is a Physical Schema?
  • Logical Schemas and Contexts
  • What Is a Logical Schema?
  • Logical Versus Physical Architecture
  • What Is a Context?
  • A Context Maps a Logical to a Physical Schema
  • Defining Contexts
  • Mapping Logical and Physical Resources

Describing the Physical and Logical Architecture

  • Describing the Physical and Logical Architecture
  • Topology Navigator
  • Defining a Context
  • Creating Physical Architecture
  • Physical Architecture View
  • Creating a Data Server
  • Creating a Data Server: JDBC
  • JDBC Driver
  • JDBC URL
  • Creating a Data Server: JNDI
  • Testing a Data Server Connection
  • Creating a Physical Schema
  • Creating Logical Architecture
  • Logical Architecture and Context Views
  • Creating a Logical Schema

Oracle Data Integrator Model Concepts

  • What Is a Model?
  • Understanding Relational Model
  • Understanding Reverse Engineering
  • Methods for DBMS Reverse Engineering
  • Other Methods for Reverse Engineering
  • Standard Versus Customized Reverse Engineering
  • Creating Models
  • How to Create a Model by Reverse Engineering
  • Selective Reverse Engineer

ODI Interface Concepts

  • ODI Interfaces
  • What Is an Interface?
  • Business Rules for Interfaces
  • Where Are the Rules Defined?
  • Mapping, Join, Filter, Lookup, and Data Sets
  • Understanding Knowledge Modules
  • Knowledge Modules
  • KM Types Used in Interfaces
  • Interfaces: An Overview
  • The Purpose of an Interface
  • Defining the Target Datastore
  • Defining the Source Datastore
  • What Is a Mapping?
  • Defining the Mappings
  • Valid Mapping Types
  • Saving the Interface
  • Executing the Interface

Designing Interfaces

  • An Overview of the Flow in ODI Interface
  • Flow
  • What Defines the Flow?
  • The Basic Process
  • Selecting a Staging Area
  • The Purpose of a Staging Area
  • Placing the Staging Area
  • Selecting the Knowledge Module
  • Which KMs for Which Flow?
  • More About KMs
  • Identifying IKMs and LKMs
  • IKMs and LKMs: Strategies and Methods
  • How to Specify an LKM
  • How to Specify an IKM
  • Common KM Options

Interfaces: Monitoring and Debugging

  • Monitoring Interfaces
  • Operator Navigator: Viewing the Log
  • Using Operator Navigator
  • Sessions, Steps, Tasks: The Hierarchy
  • Viewing Details of Sessions, Steps, and Tasks
  • How to Monitor Execution of an Interface
  • How to Troubleshoot a Session

Using ODI Procedures

  • Procedures: Overview
  • What Is a Procedure?
  • Creating a Blank Procedure
  • How to Create a New Procedure
  • Adding Commands
  • Creating a Command
  • Arranging Steps in Order
  • Which Parameters Should Be Set?
  • Valid Types of Commands
  • More Elements
  • Why Use a Source Command?
  • Adding Options
  • Types of Options
  • How to Create a New Option

Using ODI Packages

  • Packages: Overview
  • Package Diagram
  • Package Diagram Toolbar
  • Package Steps
  • How to Create a Package Step
  • What Is an ODI Tool?
  • How to Create an ODI Tool Step
  • Sequencing Steps
  • How to Sequence Package Steps
  • Executing a Package
  • Basic Step Types
  • Advanced Step Types
  • Model, Submodel, and Datastore Steps
  • How to Create Model, Submodel, and Datastore Steps
  • Models, Submodels, and Datastore Steps
  • Variable Steps
  • How to Create a Variable Step
  • Variable Steps
  • Controlling the Execution Path
  • Controlling Execution
  • Error Handling
  • Managing ODI Versions

Managing ODI Scenarios

  • What Is a Scenario?
  • Properties of Scenarios
  • Managing Scenarios
  • Scenario-Related Tasks
  • Generating a Scenario
  • Regenerating a Scenario
  • Generation Versus Regeneration
  • Executing a Scenario from the GUI
  • Executing a Scenario from a Command Line
  • Executing a Scenario from a Package
  • Exporting a Scenario
  • Preparing for Deployment

Using Web Services in ODI

  • Web Services in Action
  • Using Data Services
  • Setting Up Data Services
  • Testing Data Services
  • Installing Public Web Services
  • Using Public Web Services
  • Invoking Web Services