sitories and Agents

· Administrating the ODI Repositories 
· Creating Repository Storage Spaces 
· Creating and Connecting to the Master Repository 
· Creating and Connecting to the Work Repository 
· Managing ODI Agents 
· Creating a Physical Agent 
· Launching a Listener, Scheduler and Web Agent 
· Example of Load Balancing

ODI Topology Concepts

· Overview of ODI Topology 
· About Data Servers and Physical Schemas 
· Defining the Physical Architecture 
· Defining the Logical Architecture 
· Mapping Logical and Physical Resources 
· Defining Agents 
· Defining a Topology 
· Planning the Topology

Describing the Physical and Logical Architecture

· Overview of Topology Navigator 
· Creating Physical Architecture 
· Creating a Data Server 
· Testing a Data Server Connection 
· Creating a Physical Schema 
· Creating Logical Architecture 
· Overview of Logical Architecture and Context Views 
· Linking the Logical and Physical Architecture

Setting Up a New ODI Project

· Overview of ODI Projects 
· Creating a New Project 
· Using Folders 
· Organizing Projects and Folders 
· Understanding Knowledge Modules 
· Exchanging ODI Objects 
· Exporting and Importing Objects 
· Using Markers

Oracle Data Integrator Model Concepts

· What is a Model? 
· Understanding Metadata in ODI 
· Understanding Reverse Engineering 
· Creating Models 
· Organizing Models 
· Creating Data stores 
· Using Constraints in ODI 
· Creating Keys and References

Organizing ODI Models and Creating Data stores

· What is an Interface? 
· Business Rules for Interfaces 
· What is a Mapping? 
· What is a Join? 
· What is a Filter? 
· What is a Constraint? 
· What is a Staging Area? 
· Creating a Basic Interface
ODI Interface Concepts  

· What is an Interface? 
· Business Rules for Interfaces 
· What is a Mapping, Filter, Join? 
· Overview of Integration Process 
· What is a Staging Area? 
· About Execution Location 
· Using Knowledge Modules (KM) with ODI Interface 
· Creating a Basic Interface

Designing Interfaces

· Designing an Interface 
· Multiple Source Data stores 
· Creating Joins 
· Filtering data 
· Disabling Transformations 
· Overview of the Flow 
· Specifying the Staging Area 
· Selecting Knowledge Modules

Interfaces: Monitoring and Debugging

· Monitoring Interfaces 
· Using Operator 
· Viewing Sessions and Tasks 
· How to Monitor Execution of an Interface 
· How to Troubleshoot a Session 
· Keys to Reviewing the Generated Code 
· Working with Errors 
· Tips for Preventing Errors

 

Using ODI Packages

· What is a package? 
· Creating a package 
· Executing a package 
· Creating Advanced Packages 
· Error handling 
· Controlling an Execution Path 
· Creating a Loop 
· Using the Advanced tab

Managing ODI Scenarios and Versions

· What is a Scenario? 
· Managing Scenarios 
· Preparing Scenarios for Deployment 
· Automating Scenario Management 
· Scheduling the ODI Scenario 
· Overview of ODI version management 
· Using Version Browser and Version Comparison Tool 
· Handling concurrent changes

Enforcing Data Quality and Auditing Data with ODI

· Why Data Quality? 
· When to Enforce Data Quality? 
· Data Quality in Source Applications 
· Data Quality Control in the Integration Process 
· Data Quality in the Target Applications 
· Enforcing Data Quality 
· Exploring Your Data 
· Auditing Data Quality

Working with Changed Data Capture

· Overview of ODI version management 
· Techniques of Changed Data Capture 
· Changed Data Capture in ODI 
· CDC Strategies and Infrastructure 
· CDC Consistency 
· Using CDC 
· Viewing Data/Changed data 
· Using Journalizing