Oracle Data Integrator (ODI) 12c training
Details
This course is designed for ETL professionals and students who wish to quickly learn Oracle Data Integrator (ODI) so that they can work on an end-to-end ETL development projects. This course covers all that you will need to know to deliver an initial ETL
system, and assumes no prior knowledge up-front.
From installation through to deploying ODI, this course starts by covering architecture and deployment, creating projects to bring data from different source database to a target database. It then takes delegates through building complex interfaces, load plans
and troubleshooting the execution. New features such as real time data integration through Changed Data Capture is also covered in detail.
Who Should Attend
Developers, Consultants, Project Managers, Tech Leads, and DBAs
Previous Knowledge
Basic knowledge of SQL will be useful
Outline
Introduction
- Typical use cases and benefits.
- ODI Components.
Architecture
- ODI Architecture.
- Fusion Middleware Components.
- JDK Installation
- ODI Installation
- ODI Repositories
- Fusion Middleware Configuration
- Agent
Models and Data stores
- ODI data stores
- ODI Models;
- Reverse Engineering
- ODI constraints
- Auditing
- Data validation
Project Development
- Project creation
- Interface
- Variable
- Sequence
- Joins and Lookups
- Flow in the ODI Interface
- Knowledge modules
- User functions
- Procedure
- Package
- Scenario
- Monitoring and Troubleshooting
Execution Management
- Load Plan
- Scenario
- Session
- Monitoring and Troubleshooting
Golden Gate
- Changed Data Capture (CDC)
- Golden Gate
Speaker/s
Special Offer
Our trainers are experienced, certified, and well respected for their ability to put across their technical knowledge from years of real-world consulting experience to the classroom environment.
We offer specific training requested by clients as well as public training leading to certification.