Close
61
Oracle Fusion Middleware
25 Hours
25 Hours
2 Years
Oracle ODI Training
Date : 19 January 2018
Time : 1:30 AM
Quick Enquiry
Instructor-LedSelf-Paced





Oracle ODI Online Training at SMC details on how to use Oracle Data Integrator (ODI) to implement high-performance movement and transformation of data among various platforms. It also deals with usage of ODI graphical user interfaces that enable user to access different ODI components and resources that form ODI infrastructure. Using the graphical interfaces, you create and manage ODI repositories, which stores configuration information about the IT infrastructure, the meta data for all applications, projects, models and other ODI artifacts. You also learn how to create the ODI Topology, organize ODI models and design ODI interfaces, procedures, packages and other objects.

Who all Can Benefit from Oracle ODI Training
  • Business Analysts
  • Data Modelers
  • Database Administrators
  • Data Warehouse Administrator
  • Technical Consultant

Detailed Course Content for Oracle ODI Training

1. Introduction to Oracle ODI

  • What is Oracle Data Integrator?
  • Why Oracle Data Integrator?
  • Overview of ODI 11g Architecture
  • Overview of ODI 11g Components
  • About Graphical Modules
  • Types of ODI Agents
  • Overview of Oracle Data Integrator Repositories

2. Administrating ODI Repositories 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

3. 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

4. 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

5. Setting up a New ODI Project

  • Overview of ODI Projects
  • Creating a New Project
  • Using Folders
  • Organizing Projects and Folders
  • Understanding Knowledge ModulesExchanging ODI Objects
  • Exporting and Importing Objects
  • Using Markers

6. ODI 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

7. Organizing ODI Models and Creating Data Sources

  • 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

8. 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

9. 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

10. Interfaces : Monitoring and Debugging

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

11. Using ODI Procedures

  • What is a Procedure?
  • Examples of Procedures
  • Creating Procedures
  • Adding Commands
  • Adding Options
  • Running a Procedure
  • Using Operator to View Results

12. 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

13. 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

14. Using Web Services in ODI

  • Web Services in Action
  • Using Data Services
  • Setting Up Data Services
  • Testing Data Services
  • Installing Public Web Services
  • Using Public Web Services
  • Invoking Web Services

Certification Process

  • Once you are successfully through the project, you will be awarded with SM Consultant's Oracle ODI Training Completion Certificate.
  • SM Consultant certification has industry recognition and we are the preferred training partner for many organization's.

Frequently asked questions (FAQ'S)

You will never lose any lecture. You can choose either of the two options:
  • View the recorded session of the class available in your LMS.
  • You can attend the missed session, in any other live batch.
SM Consultant is committed to provide you an awesome learning experience through world-class content and best-in-class instructors for Oracle ODI Training. We will create an ecosystem through this training, that will enable you to convert opportunities into job offers by presenting your skills at the time of an interview. We can assist you in resume building and also share important interview questions once you are done with the training. However, please understand that we are not into job placements.
We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrolment is not possible. However, you can go through the sample class recording or scheduled demo sessions and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.
At SM Consultant, we pride ourselves on hiring and retaining the most qualified and experienced instructors in the industry. All of our instructors are certified professionals in their respective subjects. Our instructors typically have 15 or more years of real-world experience working for leading companies, allowing them to apply current trends and relevant examples to help students relate to the course material and retain more information.
You can Call us at our US Number +1.650.585.2312 OR India Number +91.8019490782 OR Email us at contact@smconsultant.com . We shall be happy to assist you.

Oracle ODI Training Reviews

Click here to submit your review.

Overall learning experience:

Quality Of Course Content:

Quality Of Training Session:

Duration Of Training:

Trainers Technical Knowledge:

Punctuality Of Trainer:

Quality Of Practice Exercises:

Response To Queries:

Submit your review
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
* Required Field
Vishal rated Oracle ODI Training : 5 Stars out of 5 Stars on Sep 08, 2015
Overall learning experience:

Quality Of Course Content:

Quality Of Training Session:

Duration Of Training:

Trainers Technical Knowledge:

Punctuality Of Trainer:

Quality Of Practice Exercises:

Response To Queries:

Very Good Training on Oracle ODI

Comments: The training delivered by smconsultant is the best oracle training I have attended, I would recommend it to anyone planning to learn oracle odi online

Official Response: Thanks for your feedback Vishal

service 0.3

0.0 0.0 0 0 Reviews for my site Oracle ODI Training
ENROLL NOW


Oracle ODI Training Reviews

Click here to submit your review.

Overall learning experience:

Quality Of Course Content:

Quality Of Training Session:

Duration Of Training:

Trainers Technical Knowledge:

Punctuality Of Trainer:

Quality Of Practice Exercises:

Response To Queries:

Submit your review
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
* Required Field
Vishal rated Oracle ODI Training : 5 Stars out of 5 Stars on Sep 08, 2015
Overall learning experience:

Quality Of Course Content:

Quality Of Training Session:

Duration Of Training:

Trainers Technical Knowledge:

Punctuality Of Trainer:

Quality Of Practice Exercises:

Response To Queries:

Very Good Training on Oracle ODI

Comments: The training delivered by smconsultant is the best oracle training I have attended, I would recommend it to anyone planning to learn oracle odi online

Official Response: Thanks for your feedback Vishal

service 0.3

0.0 0.0 0 0 Reviews for my site Oracle ODI Training