ODI Model Concepts
ïƒ˜ What is a Model? Understanding Metadata in ODI and understanding Reverse Engineering
ïƒ˜ Creating and organizing Models and Data stores, Using Constraints Keys and References in ODI

Working with KM (Knowledge Modules)
ïƒ˜ Working with LKM for Oracle, ANSI SQL, Files, XML
ïƒ˜ Working with IKM for Oracle, ANSI SQL, Files, XML
ïƒ˜ Working with data validation through CKM
ïƒ˜ Customizing Reverse Engineering Using RKM
ïƒ˜ Implementing CDC in ODI through JKM

Creating and Running ODI procedures
ïƒ˜ What is a Procedure and examples of Procedures. Creating Procedures
ïƒ˜ Adding Commands, Options, Running a Procedure and View Results with Operator

Creating and Running ODI Packages
ïƒ˜ What is a Package and how to create and execute a Package
ïƒ˜ Creating Advanced Packages, Error Handling, Controlling an Execution Path
ïƒ˜ Creating a Loop, Using the Advanced tab

Working with Changed Data Capture
ïƒ˜ Techniques of CDC and how to do it in ODI
ïƒ˜ CDC Strategies and Infrastructure, CDC Consistency. Creating Change Data Capture (CDC)
ïƒ˜ Viewing Data/Changed data, Journalizing

Administering ODI Resources: Advanced Topics
ïƒ˜ Using Open Tools, Installing Open Tools, Using Open Tools in a Package
ïƒ˜ Using Open Tools in a Procedure or in a KM and Developing Your Own Open Tools
ïƒ˜ Setting Up ODI Security, Defining Security Policies and Defining Password Policies