Fusion Blog

EBS Blog


Contact Us

  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Oracle Data Integrator Cloud Service provides all of the functionality included in Oracle Data Integrator Enterprise Edition in a single heterogeneous Cloud Service integrated with the Oracle Public Cloud. Providing an easy to use user interface combined with a rich extensibility framework.


Candidate need to have below accounts for downloading software and using Cloud services
Oracle Cloud Account
Oracle Account
AWS account

Course Contents

Day 1

Cloud Overview, Services, and ODI Architecture/Components

Oracle Data Integrator Cloud Overview

Basic Cloud Concepts (IaaS,PaaS,SaaS), Oracle DBCS , Amazon RDS.
Traditional ETL vs ODI ELT
Business use cases
ODI Architecture
Installation overview on premises and on cloud
ODI Web Console, ODI Web services

ODI Repositories and Agents

Creating Master and Work repositories
Administering repositories
Introduction to Repositories Metadata (SNP tables)
Agents and its configuration (Standalone Agent)

ODI Security and Topology

Custom profiles in security
Creating users with generic and non-generic profiles
Topology Configuration
Defining any new technology in Topology
Logical and Physical architecture
Setting data server and physical schema
Context and Agents
Defining Flex fields for objects

Day 2

ODI Variables, functions and procedures

Types of variables
Use cases of variables in work flow
User defined Functions
Native and user defined sequences
ODI procedures
Global objects (variable, functions, procedures, sequences and KMs)

Knowledge Modules

Six different Types of knowledge Modules
Knowledge module customization w.r.t. to business use cases
Technology specific KMs
Brief discussion of KM options and tasks
Introduction to java APIs and their use cases inside KMs.
Creating your own customized KM
Multi connection KM

Models and Constraints

Introduction to Models and Datastore
Defining ODI model w.r.t. Technology
Model creation through Common format designer
Reverse Engineering
Defining Datastore
ODI specific constraints on Datastore
Generating DDL scripts and Interface IN/OUT

Data Quality Control

Check Contraints
Static and Flow control
Recycle errors
Metadata tables for error diagnostics (SNP tables) 


Defining Staging Area
Use cases for defining staging area w.r.t. technology

 ODI Operator

Monitoring Integration process
Debugging integration Session and tasks
Restart mechanism
ODI job scheduling
ODI logs and log purge

Packages, Load plans and Scenarios

Introduction to package work flow
Synchronous and Asynchronous Run
Creating Scenarios for objects
Dynamic value binding in Scenarios
Business use cases for defining flow and scripting
Defining sequence of steps and running a package or scenario
Exception handling inside package
Introduction to Load plans
Serial and parallel session execution in Load plans
Flow control and exceptional handling in Load plans

ODI Designer

Project and its components
Cross – references of objects in designer navigator
Knowledge module Import
Markers and Memos
Scope of variables and other objects

Home Work: Assignments covering most of above topics

Day 3

DataWarehouse Concepts, CDC , Mapping , Migration

Use cases of ODI and Real time project implementation

Change Data capture (CDC)

CDC overview and implementation
Journalizing Knowledge module(JKM)

Data warehousing

Data warehousing basics and overview
Dimension and Facts
Star and snowflake schemas

 Interface (Mapping)

Navigation and mapping editor
Mapping creation with multiple targets 12c
Defining LKM, IKM and CKM inside mapping
Implementation of business logic inside mapping
Defining datasets and lookups
Physical and Logical mapping (12c)
Reusable mapping (12c)
Data warehousing implementation using reusable mapping
Designing ETL vs ELT mapping

 ODI components

Overview and implementation
Joins and filters
Split and sort
Lookup and Distinct

Code Migration

Different techniques for code migration
Smart import and Export
Unique internal Ids and GUID
Unique repositories IDs
Export and Import Hierarchy
Setting up production environment 

Day 4

Working with XML and Different technologies

Working with Different Technologies

File and table transformations
XML transformations
Working with delimited and fixed file format

Version Controlling

Version controlling
Implementation versions in Solutions
Maintain versions with metadata
External code backup

ODI through Web Services

Introduction to ODI web services
J2EE agent and its advantage
ODI console
Invoking third party web services
Managing Executions using web services

Working with Cloud

Installation of ODI on Cloud env (Oracle/AWS)
Working with FTP/SFTP server
Performing bulk data integration
Working with XML 

ODI Performance Tuning

Mapping optimization (data movement reduction)
Runtime optimization (Agent location)
Load balancing
Mapping loading strategies 



Training Hours

Start Date: 28th September 2019

Training Schedule: 28, 29 Sep, 05 & 06th Oct 2019

Timing: 12:00 NOON GMT | 08:00AM EST | 5:00AM PST | 7:00AM CST | 6:00AM MST | 5:30PM IST  | 01:00PM GMT+1

This training will run for 4 days over weekends


About the Author


Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Apr 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
     1  2  3  4
  5  6  7  8  91011

Enquire For Training

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner