ODI 11G

ODI Trainer's Profile:

ETL Trainer has around good exposure in Warehousing. He is working in Fortune 500 Company and has worked in Data modelling, Relational Modelling, Star Schemes, Snowflake Schemas, PLSQL Development. He has been part of many corporate training's.

DAY BY DAY CONTENT

DAY 1

Introduction to Data warehouse

Approaches to Data Warehousing

Difference between ETL adn ELT Architecture

Introduction to Oracle Data Integrator (ODI)

Overview of ODI Components

Introduction to ODI Architecture

DAY 2

Introduction to ODI components

Topology Manager

Designer

Operator

Security Manager

Java J2EE Components ( Only Required when Using ODI with Weblogic Server)

ODI Console ( Only Required when Using ODI with Weblogic Server)

Difference between ODI 10g and ODI 11G

ODI Installation Demo (Optional)

ODI Repository setup Architecture

ODI Logical Architecture

DAY 3

Overview of ODI's Topology Manager Components

Physical Architecture: Technology, Data Server, Physical Schema, Physical Agent

Logical Architecture: Technology, Logical Schema, Logical Agent

Context

ODI Agents

Repositories

Creating Data Server, Physical Schema, Logical Schema, Context for different Technologies (Oracle, File, CSV, MS Excel, XML, Etc)

DAY 4

Introduction to ODI Knowledge Modules (Integration, Loading, Check, Journalizing, Reverse, Service

Introduction to ODI Designer Components

Models, Projects, Datastores, Interfaces, Procedures, Pacakages, Variables, Sequences, Knowledge Modules, User Functions, Global objects

Introduction to Reverse Engineering in ODI

Creating and Reversing Models in ODI for different technologies (Oracle, File, XML, Ms Excel, Etc )

DAY 5

Creating ODI Interfaces

Using Knowledge Modules in ODI Interfaces

Working with different types of Joins, Transformations, Expressions in ODI Interfaces

Working with ODI Procedures

Working with ODI Variables, Sequences, User Functions

DAY 6

ODI with ODI Packages, Generating ODI scenarios and their Usability

Creating Different Kinds of Interfaces

Using Interfaces, Procedures, variables in Packages for defining work flows

Introduction to ODI's Operator and functions of Operator

DAY 7

 Introduction to ODI Security Manager

Creating ODI Users and Working with User Profiles

Introduction to ODI's Advanced Features - Changed Data Capture (CDC) Features and Using Journalizing in ODI

Q&A Session

DAY 8

Project Assignment

Approach for Assignment Projects

Understanding on Real Time Projects

Suggestions in Resume Prepration

DAY 9

Project assignment discussion and Q&A

Interview Prepartion

Walk through of real time interfaces for better understanding

Packages and scenarios executions

Using agents for command line executions including use of startup variables

Pending topics which are left will be taken over in this session