LIVE Instructor-Led Courses
Dismiss

Oracle ODI Development - Advanced training course

Attend An Advanced Oracle ODI Developer Course - Learn to Develop Applications Within Your Data Integration Installation

JBI training course London UK

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022

JBI training course London UK

  • Product Installation
  • Developing ODI Knowledge Modules
  • Designing Advanced Integration Interfaces
  • Using variables
  • Using Groovy in ODI
  • Using Complex Files
  • Working with Changed Data Capture
  • Selecting Integration Strategies
  • ODI and Big Data

 

Developing ODI Knowledge Modules

    Overview of Different Types of KMs

    Guidelines for KM Developers

    Working with Substitution Methods

    Applying Various ODI Tags

    Implementing Java in KMs

    Troubleshooting and Debugging KMs

 

Designing Advanced Integration Interfaces

    Designing Integration Interfaces: E-LT and ETL - Style Interfaces

    Selecting LKM and Mono-Connection (Single Technology) IKM

    Applying Best Practices for Integration Interfaces Design

    Designing Temporary Interfaces

    Implementing Lookups

    Combining Multiple Datasets

    Using Set-Based Operators

    Partitioning ODI Datastores

 

Using variables

    Describing a Variable's Scope

    Inserting Variables in Object Properties

    Using Variables within Variables

    Defining Variables in the Resource Name of a Datastore

    Applying Variables in Topology Objects

    Setting Variables as Start Up Parameters

    Tracking Variables

 

Using Groovy in ODI

    Interacting Programmatically with ODI

    Overview of ODI SDK

    Introduction to Groovy

    Using Groovy Editor

    Automating Development Tasks with Groovy

 

Using Complex Files

    What are Complex Files

    Determining Technical Requirements for Complex Files Project

    Applying nXSD Schema: an Example

    Setting up the Topology for Complex Files

    Creating and Reverse-Engineering a Complex Files Model

    Designing an Interface with Complex Files

 

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

    Using CDC

    Viewing Data/Changed data

    Using Journalizing

 

 

Selecting Integration Strategies

    Loading and Integration Patterns

    Selecting Staging Area Location

    Working with Slowly Changing Dimensions (SCD)

    Working with Changed Data Capture

    Using ODI with Oracle GoldenGate

 

ODI and Big Data

    Describe Big Data concepts

    Contrast Hadoop, NoSQL, Apache, Hive, HBase, HDFS

    Implement ODI mapping for Big Data to Oracle SQL

 

JBI training course London UK

This course is for ETL Developers who already know ODI, but wish to extend their knowledge of the this tool.

4.8 out of 5 average

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022



“JBI  did a great job of customizing their syllabus to suit our business  needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and  the Instructor handled this particularly well - very impressive”

Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022

 

 

JBI training course London UK
 
Article : Top 20 "Pain Points" for Data Analysts
 

Problem 11 : You have a very complex Excel spreadsheet and you want to reproduce EXACTLY the same spreadsheet in Power BI
Solution: Power BI is not Excel, it works differently and it has different strengths. In order to tackle this issue the best way is going back to the source and try to...

See this article in our latest Newsletter



CONTACT
+44 (0)20 8446 7555

enquiries@jbinternational.co.uk

SHARE

Corporate Policies     Terms & Conditions
JB International Training Ltd  -  Company number 08458005

Registered address Wohl Enterprise Hub 2B Redbourne Avenue London N3 2BS

POPULAR

Rust training course                                                                          React training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Kubernetes training course                                                            C++ training course

Power Automate training course                               Clean Code training course