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
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) 

ELT vs ETL

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