Introduction to Oracle Data Integrator (ODI)

·       Describe the benefits of ODI and its typical use cases

·       Describe the ODI components and their uses

 

Architecture Overview

·       Install and configure the physical and logical architecture

·       Explain Fusion Middleware Components including Upgrade Assistant, Repository Creation Utility, and Java Enterprise Edition (JEE) Components

·       Explain the differences between the different ODI Agent types

 

ODI Models and Datastores

·       Create ODI datastores

·       Create and organize ODI models 

·       Use reverse engineering metadata

·       Explain ODI constraints

·       Configure auditing

 

Project Development

·       Create a project within ODI

·       Explain an ODI mapping

·       Describe the concepts of expressions, components as well as the concepts of staging area and execution location

·       Use mapping components and expressions

·       Configure the physical design of a mapping (knowledge modules, staging area and execution location)

·       Create and execute an ODI mapping

·       Modify and develop knowledge modules

·       Describe run time

·       Monitor the execution of interfaces

·       Troubleshoot and prevent run-time errors in mappings

·       Describe the use of reusable Mappings

 

Managing Execution

·       Use ODI packages to create a complete workflow

·       Use variables in packages (refresh, startup parameters).

·       Create package steps of different types

·       Execute and monitor a package

·       Use complex workflows in ODI packages, including branches and loops

·       Design a sequence of hierarchical steps in a load plan

·       Compare packages and load plans

·       Manage exceptions with load plans

·       Configure load plans to restart child sessions

 

Integrating OGG with ODI

·       Describe the purpose of Changed Data Capture (CDC) with ODI

·       Explain ODI CDC with GoldenGate - this is learner level…please update

·       Perform ODI journalizing 

·       Interpret and troubleshoot the results of CDC

 

Doing more with ODI

·       Configure the ODI Software Development Kit (SDK)

·       Install the Web-based components of ODI

·       Explain how ODI is used with Big Data technologies