Oracle ODI Development - Advanced Training Course

 

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