Oracle Data Integrator Training Course Content

Spread the love

Oracle Data Integrator Training Course Content Details

What is Oracle Data Integrator

Oracle information planimeter (ODI) is associate Extract, load and rework (ELT) (in distinction with the ETL common approach) tool created by Oracle that provides a graphical atmosphere to create, manage and maintain information integration processes in business intelligence systems.ODI Training in hyderabad kukatpally
Oracle purchased Sunopsis in Oct 2006 and re-branded it as Oracle information planimeter (ODI). The aim of this acquisition was to reinforce the Oracle Fusion Middleware providing, that needed broad support to heterogeneous sources and targets. when the acquisition Oracle continuing to supply one by one ODI in addition as its former ETL product Oracle Warehouse Builder. On January 2010 Oracle declared their intention to merge them into one product (Oracle information planimeter Enterprise Edition).
It is wont to extract information from a range of information sources (relational databases, flat files, etc.), perform complicated information transformations, and cargo information into a range of target information stores (data warehouses, application databases, flat files, etc.). for more info click here




ODI Course Content

01.Identifying the Course Units

  • What is Oracle Data Integrator?
  • Why Oracle Data Integrator?
  • Overview of ODI 11g Architecture
  • Overview of ODI 11g Components
  • About Graphical Modules
  • Types of ODI Agents
  • Overview of Oracle Data Integrator Repositories

02.Administering ODI Repositories and Agents

  • Administrating the ODI Repositories
  • Creating Repository Storage Spaces
  • Creating and Connecting to the Master Repository
  • Creating and Connecting to the Work Repository
  • Managing ODI Agents
  • Creating a Physical Agent

03.ODI Topology Concepts

  • Overview of ODI Topology
  • About Data Servers and Physical Schemas
  • Defining the Physical Architecture
  • Defining the Logical Architecture
  • Mapping Logical and Physical Resources
  • Defining Agents
  • Defining a Topology
  • Planning the Topology

04.Describing the Physical and Logical Architecture

  • Overview of Topology Navigator
  • Creating Physical Architecture
  • Creating a Data Server
  • Testing a Data Server Connection
  • Creating a Physical Schema
  • Creating Logical Architecture
  • Overview of Logical Architecture and Context Views
  • Linking the Logical and Physical Architecture




05.Setting Up a New ODI Project

  • Overview of ODI Projects
  • Creating a New Project
  • Using Folders
  • Organizing Projects and Folders
  • Understanding Knowledge Modules
  • Exchanging ODI Objects and Sharing Global Objects
  • Exporting and Importing Objects
  • Using Markers

06.Oracle Data Integrator Model Concepts

  • What is a Model?
  • Understanding Metadata in ODI
  • Understanding Reverse Engineering
  • Creating Models
  • Organizing Models
  • Creating Data stores
  • Using Constraints in ODI
  • Creating Keys and References

07.Organizing ODI Models and Creating Data stores

  • What is an Interface?
  • Business Rules for Interfaces
  • What is a Mapping?
  • What is a Join?
  • What is a Filter?
  • What is a Constraint?
  • What is a Staging Area?
  • Creating a Basic Interface

Oracle Data Integrator Training Demo






Contact Us for Oracle Data Integrator Online and Classroom Training

venkat: 9059868766
email:[email protected]
Address: PlotNo 126/c,2nd floor,Street Number 4, Addagutta Society, Jal Vayu Vihar, Kukatpally, Hyderabad, Telangana 500085

Sharing is caring!

Updated: May 10, 2017 — 9:46 am

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.