Oracle ODI Training | oracle Data Integrator Online Training – GOT

1
www.globalonlinetrainings.com

ORACLE ODI TRAINING At Global Online Trainings
Email info_at_globalonlinetrainings.comIND
914060501418UK 44(0) 203 371 00 77Whats app
1 516 8586 242
Visit us https//www.globalonlinetrainings.com
2
Global Online Trainings
To give an overview Global Online Training
services corporation specializing in providing
Online trainings to individuals and
enterprises. Our high quality, competitive and
effective training services makes us the best in
this field. Our professional team carries
excellent instructional experience through many
years and understands the complexity of the
technology and methods of training delivery. we
provide the trainings with Subject Matter
Experts(SMEs) who has good experience in their
primary skills, currently we have more tutors in
all the technologies for online trainings and
corporate trainings. We provide trainings for
below technologies 1.SAP(All Modules) 2.Oracle(All
Modules) 3.SAS(All Modules) 4.IBM
Tools 5.Microsoft Applications 6.Web Technologies
and Other technologies 7.Middleware tools
3
Oracle ODI Training Introduction
Oracle data integrator is an ETL tool. ETL means
extract transform and load. These are the three
database functions that are offered by ETL tools
in order to pull out data from one database and
place that data into another database. ODI is an
ELT tool. ELT is a new approach to populate data
warehouses. It offers efficiency by taking
advantage of cluster computing resources. In the
past Oracle is used to sell oracle warehouse
builder called OWB. Later on Oracle purchased
Oracle data integrator. ODI includes the basic
functionality of OWP. Oracle ODI Training is
rendered by industry experts with latest updates.
4

• Overview of Oracle ODI Training
• ODI has mainly two advantages.
• The data transformations take place on the target
  database using SQL.
• It offers transparency. So the developers can
  find that what exactly is happening. It is great
  for debugging. The other advantage is the code
  template approach which enables reusability.
• In Oracle ODI Training, ODI can be used in
  several type of projects. For example, it can be
  used in Conventional Data Integration, Business
  Intelligence and Data Warehousing, Modernization
  Initiatives, Migrations and Consolidations,
  Service oriented architecture initiatives and
  Master data management.

5
ODI Dataflow Architecture The main function of
a data integration tool like ODI is to transfer
data from source to target. That means data needs
to be transferred from a source database to a
target database. Oracle ODI is a java-based
application which needs to be installed on a
relational database. It contains two main
repositories. They are master repository and
work repository. These repositories are used to
store the ODI components like programs, metadata
connection details, user details etc., The
complete information about Oracle ODI Dataflow
architecture can be explained during Oracle ODI
Training.
6
Scenarios in Oracle ODI Training A scenario is
compiled or executable object. It can be used for
scheduling or executing and is not editable. We
can generate scenarios for Packages, Procedures,
Interfaces, Variables. We can create scenarios in
ODI under procedures or packages or
interface. Mapping in ODI In order to move
source table data to target database, we need
mapping between source and target table. ETL
mapping documents contains source, staging area,
target and the business rules information. And it
is the most important document for the developer.
The more you will understand about the mapping
during the Oracle ODI Training.
7

Thank you