• No products in the cart.

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.

PRIVATE
Course Access

Unlimited Duration

Last Updated

March 5, 2021

Students Enrolled

Total Reviews

Posted by
Certification

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
    • Topology Navigator 00:00:00
    • Creating Physical Architecture 00:00:00
    • Creating Logical Architecture 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
    • Understanding the Relational Model 00:00:00
    • Understanding Reverse-Engineering 00:00:00
    • Creating Models 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
    • ODI Mappings 00:00:00
    • Expressions, Join, Filter, Lookup, Sets, and Others 00:00:00
    • Behind the Rules 00:00:00
    • Staging Area and Execution Location 00:00:00
    • Understanding Knowledge Modules 00:00:00
    • Mappings: Overview 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
    • Monitoring Mappings 00:00:00
    • Working with Errors 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
    • Partitioning 00:00:00
    • Configuring Reusable Mappings 00:00:00
    • Using User Functions 00:00:00
    • Substitution Methods 00:00:00
    • Modifying Knowledge Modules 00:00:00
    • +- 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
    • Packages: Overview 00:00:00
    • Executing a Package 00:00:00
    • Review of Package Steps 00:00:00
    • Model, Submodel, and Datastore Steps 00:00:00
    • Variable Steps 00:00:00
    • Controlling the Execution Path 00:00:00
    • Starting a Debug Session 00:00:00
    • New Functions 00:00:00
    • Menu Bar Icons 00:00:00
    • Scenarios 00:00:00
    • Managing Scenarios 00:00:00
    • Preparing for Deployment 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
    • Data Quality 00:00:00
    • Business Rules for Data Quality 00:00:00
    • Enforcing Data Quality with ODI 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
    • Setting Up ODI Security 00:00:00
    • Managing ODI Reports 00:00:00
    • ODI Integration with Java 00:00:00

    Course Reviews

    Profile Photo
    ashar hafeez
    0
    62

    Students

    About Instructor

    Pak

    Course Events

    [wplms_eventon_events]

    More Courses by Insturctor

    © 2021 Ernesto.  All rights reserved.  
    X