ODI Online Training

Syllabus of ODI Online Training Course

Module 1: INTRODUCTION

• 1.Identifying the Course Content
• 2.What is Oracle Data Integrator
• 3.Why Oracle Data Integrator
• 4.Overview of ODI 11g Architecture
• 5.Overview of ODI 11g Components
• 6.About Graphical Modules
• 7.Types of ODI
• 8.Overview of Oracle Data Integrator Repositories

Module 2: INSTALLATIONS & CONFIGURATIONS

• 1.Oracle 11G Database
• 2.ODI 11G
• 3.Weblogic Server 11G
• 4.Configurations

Module 3: ADMINISTERING ODI REPOSITORIES AND AGENTS

• 1.Administrating the ODI Repositories
• 2.Creating Repository Storage Spaces
• 3.Creating and Connecting to the Master Repository
• 4.Creating and Connecting to the Work Repository
• 5.Managing ODI Agents
• 6.Creating a Physical Agent
• 7.Launching a Listener, Scheduler and Web Agent
• 8.Example of Load Balancing

Module 4: ODI TOPOLOGY CONCEPTS

• 1.Overview of ODI Topology
• 2.About Data Servers and Physical Schemas
• 3.Defining the Physical Architecture
• 4.Defining the Logical Architecture
• 5.Mapping Logical and Physical Resources
• 6.Defining Agents
• 7.Defining a Topology
• 8.Planning the Topology

Module 5: DESCRIBING THE PHYSICAL AND LOGICAL ARCHITECTURE

• 1.Overview of Topology Navigator
• 2.Creating Physical Architecture
• 3.Creating a Data Server
• 4.Testing a Data Server Connection
• 5.Creating a Physical Schema
• 6.Creating Logical Architecture
• 7.Overview of Logical Architecture and Context Views
• 8.Linking the Logical and Physical Architecture

Module 6: SETTING UP A NEW ODI PROJECT

• 1.Overview of ODI Projects
• 2.Creating a New Project
• 3.Using Folders
• 4.Organizing Projects and Folders
• 5.Understanding Knowledge Modules
• 6.Exchanging ODI Objects
• 7.Exporting and Importing Objects
• 8.Using Markers

Module 7: ORACLE DATA INTEGRATOR MODEL CONCEPTS

• 1.What is a Model
• 2.Understanding Metadata in ODI
• 3.Understanding Reverse Engineering
• 4.Creating Models
• 5.Organizing Models
• 6.Creating Data stores
• 7.Using Constraints in ODI
• 8.Creating Keys and References

Module 8: ORGANIZING ODI MODELS AND CREATING DATA STORES

• 1.What is an Interface
• 2.Business Rules for Interfaces
• 3.What is a Mapping
• 4.What is a Join
• 5.What is a Filter
• 6.What is a Constraint
• 7.What is a Staging Area
• 8.Creating a Basic Interface

Module 9: ODI INTERFACE CONCEPTS

• 1.What is an Interface
• 2.Business Rules for Interfaces
• 3.What is a Mapping, Filter, Join
• 4.Overview of Integration Process
• 5.What is a Staging Area
• 6.About Execution Location
• 7.Using Knowledge Modules (KM) with ODI Interface
• 8.Creating a Basic Interface

Module 10: DESIGNING INTERFACES

• 1.Designing an Interface
• 2.Multiple Source Data stores
• 3.Creating Joins
• 4.Filtering data
• 5.Disabling Transformations
• 6.Overview of the Flow
• 7.Specifying the Staging Area
• 8.Selecting Knowledge Modules

Module 11: INTERFACES: MONITORING AND DEBUGGING

• 1.Monitoring Interfaces
• 2.Using Operator
• 3.Viewing Sessions and Tasks
• 4.How to Monitor Execution of an Interface
• 5.How to Troubleshoot a Session
• 6.Keys to Reviewing the Generated Code
• 7.Working with Errors
• 8.Tips for Preventing Errors

Module 12: DESIGNING INTERFACES: ADVANCED TOPICS

• 1.Using Business Rules in Interfaces
• 2.Overview of Business Rule Elements
• 3.Using variables
• 4.Using User Functions
• 5.Using Substitution Methods
• 6.Modifying a KM
• 7.Developing Your Own KM
• 8.Using RKM for Customized Reverse Engineering

Module 13: USING ODI PROCEDURES

• 1.What is a Procedure
• 2.Examples of Procedures
• 3.Creating Procedures
• 4.Adding Commands
• 5.Adding Options
• Running a Procedure
• 6.Using Operator to View Results

Module 14: USING ODI PACKAGES

• 1.What is a package
• 2.Creating a package
• 3.Executing a package
• 4.Creating Advanced Packages
• 5.Error handling
• 6.Controlling an Execution Path
• 7.Creating a Loop
• 8.Using the Advanced tab

Module 15: MANAGING ODI SCENARIOS AND VERSIONS

• 1.What is a Scenario
• 2.Managing Scenarios
• 3.Preparing Scenarios for Deployment
• 4.Automating Scenario Management
• 5.Scheduling the ODI Scenario
• 6.Overview of ODI version management
• 7.Using Version Browser and Version Comparison Tool
• 8.Handling concurrent changes

Module 16: ENFORCING DATA QUALITY AND AUDITING DATA WITH ODI

• 1.Why Data Quality
• 2.When to Enforce Data Quality
• 3.Data Quality in Source Applications
• 4.Data Quality Control in the Integration Process
• 5.Data Quality in the Target Applications
• 6.Enforcing Data Quality
• 7.Exploring Your Data
• 8.Auditing Data Quality

Module 17: WORKING WITH CHANGED DATA CAPTURE

• 1.Overview of ODI version management
• 2.Techniques of Changed Data Capture
• 3.Changed Data Capture in ODI
• 4.CDC Strategies and Infrastructure
• 5.CDC Consistency
• 6.Using CDC
• 7.Viewing Data/Changed data
• 8.Using Journalizing

Module 18: ADMINISTERING ODI RESOURCES: ADVANCED TOPICS

• 1.Using Open Tools
• 2.Installing Open Tools
• 3.Using Open Tools in a Package
• 4.Ysing Open Tools in a Procedure or in a KM
• 5.Developing Your Own Open Tools
• 6.Setting Up ODI Security
• 7.Defining Security Policies
• 8.Defining Password Policies