ODI Training

For more details contact us at +91-720-720-9005 ( Whats app ) or www.dwbiadda.com

Introduction

1. What is Oracle Data Integrator?
2. Why Oracle Data Integrator?
3. Overview of ODI 12c Architecture
4. Overview of ODI 12c Components
5. About Graphical Modules
6. Types of ODI Agents
7. Overview of Oracle Data Integrator Repositories

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. Example of Load Balancing

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

Describing the Physical and Logical Architecture

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

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. Using Markers

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 Datastores
7. Using Constraints in ODI
8. Creating Keys and References

Organizing ODI Models and Creating Datastores

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

Knowledge Modules

1. What is Knowledge Module
2. Different types of KM
3. Customization of KM

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. About Execution Location
6. Using Knowledge Modules (KM) with ODI Interface
7. Creating a Basic Interface

Designing Interfaces

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

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

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

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. Scheduling the scenarios

IMPLEMENTING SLOWLY CHANGING DIMENSIONS

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 Consistency
5. Using CDC
6. Viewing Data/Changed data
7. Using Journalizing

Working with Flat-Files

1. What is flat-file?
2. Types of flat files
3. Reverse engineering the metadata from flat files
4. Error handling while importing flat files