Reviews 4.9 (4.6k+)
Rated 4.7 out of 5
ODI (Oracle Data Integrator) Training
One of the top providers of online IT training worldwide is VISWA Online Trainings. To assist beginners and working professionals in achieving their career objectives and taking advantage of our best services, We provide a wide range of courses and online training.
About Course
Oracle Data Integrator (ODI) Course Overview
Our Oracle Data Integrator (ODI) Online Training is designed to provide learners with in-depth knowledge of data integration, transformation, and ETL processes using Oracle’s high-performance ODI platform. This course covers everything from basic data mapping to advanced integration techniques, error handling, and performance optimization. Whether you are a data engineer, BI developer, or ETL professional, this training helps you streamline data flows, manage large datasets, and implement enterprise-grade integration solutions.
Who Can Enroll:
- Data Engineers
- ETL Developers
- BI/DW Developers
- Database Administrators
- IT Professionals involved in data integration projects
Course Benefits:
- Gain hands-on experience in designing, implementing, and monitoring ETL processes
- Learn data extraction, transformation, and loading with ODI mappings
- Understand error handling, data quality, and performance optimization
- Integrate data from multiple sources and systems efficiently
- Enhance career opportunities in data warehousing, ETL development, and business intelligence
ODI Training Course Syllabus
Week 1
- ETL And ELT Architectures
- Introduction To ODI
- ODI Components
- Topology Manager
- Repositories
- Master Repository
- Work RepositoryPhysical and Logical Architectures
- Data servers
- Schema
- Agents
- Contexts
- Security Manager
- Users
- Hosts
- Objects
- Profiles
- Designer
- Models
- Projects
- Variables
- Sequences
- User Functions
- Knowledge Modules
- Markers
- Interfaces
- Packages
- Procedures
- Other
- Global Variables
- Global Sequences
- Global User Functions
- Global Markers
- Operator
- Session List
- Hierarchical Sessions
- Scheduling
- Scenarios
Week 2
- Creating mappings with different scenarios
- ODI Setup
- ODI Installation
- Creation of DB Schemas for repositories
- Creation of Master Repository
- Creating a Connection to Master Repository
- Creation of a Work Repository
- Topology-Connection Creation
- Creation of a Context
- Creation of Data Servers
- Creation of Physical & Logical Schema
- Creation of Physical and Logical Agents
- Grouping Logical schema & logical Agents with the Context
- Designer
- Creation of Data Models
- Importing Source and Target tables metadata
- Creation of an ODI Project
- Importing Required Knowledge modules
- Creation of an Interface
- Mapping Source and Target columns in the Interface
- Creating a Scenario
- Executing the interface
- Operator
- Monitoring the Session Logs
- Knowledge Modules
- Reverse-Engineering Knowledge Modules (RKM)
- Check Knowledge Modules (CKM)
- Load Knowledge Modules (LKM)
- Integration Knowledge Modules (IKM)
- Journalizing Knowledge Modules (JKM)
- Service Knowledge Modules (SKM)
Week 3
- Working with
- Filters
- Joins
- Procedures
- Functions
- Variables
- Set Operations
- Lookup
- Scheduling
- Tools
- OS Command
- OdiBeep
- OdiSendMail
- OdiSleep
- OdiStartScen
- OdiWaitForData
Week 4
- SCD Types Understanding
- SCD Type-1
- SCD Type-2
- SCD Type-3
- Load Plans
- Import/export & versioning
- Case Studies
- BI APPS Understanding
ODI Course Key Features
- Live Instructor based training with software
- Certification Oriented content
- Hands-on complete Realtime training
- Flexible schedule demo's & classes
- Live recorded videos access
- Study material provided
- JOB Assistance
Course completion certificate
ODI Training - Upcoming Batches
Coming Soon
AM IST
Coming Soon
AM IST
Coming Soon
PM IST
Coming Soon
PM IST
Don't find suitable time ?
Request More Information
CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE
Live Virtual Training
- Schedule your sessions at your comfortable with timings
- Instructor-Led training real time projects
- Certification Guidance
PREFERRED
Self-Paced Learning
- Complete set of live-online training session recorded videos.
- Learn technology at your own pace.
- Get access for lifetime.
Corporate Training
- Learn as a full day schedule with discussions, exercises.
- Practical use cases.
- Design your own syllabus based
FOR BUSINESS
ODI Online Training FAQ'S
What is Oracle Data Integrator (ODI)?
ODI is Oracle’s data integration and ELT platform that provides high-performance data extraction, loading, and transformation between multiple heterogeneous systems.
What is the difference between ETL and ELT in ODI?
ODI follows the ELT (Extract, Load, Transform) approach, where raw data is first loaded into the target system and then transformed inside the database for faster performance, unlike traditional ETL.
What are Knowledge Modules (KMs) in ODI?
Knowledge Modules are predefined templates in ODI that contain the actual code for loading, integrating, and validating data. Types include Loading KM, Integration KM, and Check KM.
What is an ODI Agent?
An ODI Agent is a lightweight Java process that executes ETL jobs, manages scheduling, monitors execution, and logs integration processes.
What is a Load Plan in ODI?
A Load Plan is a sequence of steps and scenarios that define the execution order of complex ETL workflows in ODI. It ensures controlled and optimized data integration.
Reviews
More Courses You Might Like
No posts found!