ODI Training

ODI Training Course Syllabus
Oracle Data Integrator Overview

• Traditional ETL vs ODI ELT
• Business use cases
• ODI Architecture
• Installation overview

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 Configuratiuon
• Defining any new technology in Topology
• Logical and Physical architecture
• Setting data server and physical schema
• Context and Agents
• Defining Flexfields for objects

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
• Partitioning
• 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

Change Data capture (CDC)

• CDC overview and implementation
• Static and consistent CDC
• Trigger based CDC
• Golden gate CDC
• Timestamp based CDC
• Journalizing Knowledge module(JKM)

Data warehousing

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

Slowly changing Dimension (SCD)

• SCD overview
• SCD type 1,2 and 3
• SCD implementation inside Models
• Knowledge Module customization for SCD
• Integration of dimension and facts table (end to end cycle)

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)
• Defining options inside KM

• Temporary Interface (11g)
• Reusable mapping (12c)
• Data warehousing implementation using reusable mapping
• Designing ETL vs ELT mapping

ODI components

• Overview and implementation
• Joins and filters
• Aggregation (not available in 11g and its work around)
• Expression
• Datasets
• 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

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 Tools Reference

• Tools guide
• Different file Tools
• Object related tools• Execution tools
• Tool Customization

ODI through Web Services

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

ODI Performance Tuning

• Mapping optimization (data movement reduction)
• Runtime optimization(Agent location)
• Load balancing
• Mapping loading stratagies.


• Integration of Big data and hadoop in ODI
• Integration with Nosql databases

• Implementing Jython code in ODI procedures
• Knowledge Module customization complex use cases
• Implementation of Java Grovvy within ODI

    Footer Sidebar 7
    Curabitur quis tempus ipsum. Vivamus tincidunt sollicitudin facilisis. Phasellus elementum tortor eu magna tincidunt lacinia. Nullam ac nulla vel enim molestie luctus. In et tempus purus, ac tempor metus. Vestibulum quis semper lorem, sed tempus turpis. Cras lobortis erat ipsum, sed venenatis lacus blandit eget. Mauris sed pharetra felis, ut fringilla odio. Phasellus vitae libero ut lectus sagittis porttitor.

    Etiam magna arcu, ullamcorper ut pulvinar et, ornare sit amet ligula. Aliquam vitae bibendum lorem. Cras id dui lectus. Pellentesque nec felis tristique urna lacinia sollicitudin ac ac ex. Maecenas mattis faucibus condimentum. Curabitur imperdiet felis at est posuere bibendum. Sed quis nulla tellus.


    63739 street lorem ipsum City, Country


    +12 (0) 345 678 9



    Quick Enquiry
    Thank You. We will contact you as soon as possible.