ratingsÂ
Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services.
Unlimited Duration
March 5, 2021
This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. In this course you will learn about,
· Administer ODI resources and setup security with ODI
· Apply ODI Topology concepts for data integration
· Describe ODI Model concepts
· Describe architecture of Oracle Data Integrator
· Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations
· Explore, audit data, and enforce data quality with ODI
· Implement Changed Data Capture with ODI
Course Curriculum
-
- Oracle Data Integrator: Introduction 00:00:00
- Oracle Data Integrator Repositories 00:00:00
-
- Create and connect to the Master Repository 00:00:00
- Export and import the Master Repository 00:00:00
- Create, connect, and set a password to the Work Repository 00:00:00
- ODI Topology: Overview 00:00:00
- Data Servers and Physical Schemas 00:00:00
- Defining Topology 00:00:00
- Agents in Topology 00:00:00
- Planning a Topology 00:00:00
- ODI Projects 00:00:00
- Using Folders 00:00:00
- Understanding Knowledge Modules 00:00:00
- Exporting and Importing Objects 00:00:00
- Using Markers 00:00:00
- Organizing Models 00:00:00
- Creating Datastores 00:00:00
- Constraints in ODI 00:00:00
- Creating Keys and References 00:00:00
- Creating Conditions 00:00:00
- Exploring Your Data 00:00:00
- Constructing Business Rules 00:00:00
- Multiple Sources and Joins 00:00:00
- Filtering Data 00:00:00
- Overview of the Flow in ODI Mapping 00:00:00
- Selecting a Staging Area 00:00:00
- Configuring Expressions 00:00:00
- Execution Location 00:00:00
- Selecting a Knowledge Module 00:00:00
- Working with Business Rules 00:00:00
- Using Variables 00:00:00
- Datasets and Sets 00:00:00
- Using Sequences 00:00:00
- Procedures: Overview 00:00:00
- Creating a Blank Procedure 00:00:00
- Adding Commands 00:00:00
- Adding Options 00:00:00
- Running a Procedure 00:00:00
- Starting a Debug Session 00:00:00
- New Functions 00:00:00
- Menu Bar Icons 00:00:00
- What are load plans? 00:00:00
- Load plan editor 00:00:00
- Load plan step sequence 00:00:00
- Defining restart behavior 00:00:00
- CDC with ODI 00:00:00
- CDC implementations with ODI 00:00:00
- CDC implementation techniques 00:00:00
- Journalizing 00:00:00
- Results of CDC 00:00:00
Course Reviews

Students