MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

ODI 11g Hands On Tutorials

Course Summary

Oracle Data Integrator 11g Video Tutorials

  • +

    Course Syllabus

    • Overview of Oracle data integrator
      • ETL vs ELT
      • ETL & ELT Concepts
      • ETL and ELT Approaches
      • ETL and ELT approaches
      • Introduction to Oracle Data Integrator 11g
      • Introduction to oracle Data integrator
      • Oracle Data Integrator overview
      • Overview of Oracle data integrator
      • ODI Studio Components
      • ODI Studio Components
      • ODI Repositories
      • ODI Repositories
      • Optional: Overview of Oracle Data Integrator
    • Product Installation
      • Demonstration scripts and Files
      • Lecture:7 Oracle Data Integrator Developer Installation
      • Oracle Data Integrator Developer Installation Document
      • Creating Schemas for repositories
      • Creating Master Repository
      • Creating connection to Master Repository
      • Creating work Repository
      • Attaching work Repository to Master Repository
    • Topology Setup
      • Setting up Topology
      • Hide unused Technologies
    • Models
      • Creating Models and Reverse Engineering
      • Querying Data store
      • ODI Data store & Counting number of rows
    • Project and Interfaces
      • Creating an Integration Project
      • Introduction to Knowledge Modules
      • Types of Knowledge modules
      • Optional: Knowledge Module usage
      • Importing Knowledge Modules
      • Introduction to Business rules
      • Creating Simple Interfaces
      • Debugging Interfaces using Operator
      • Optional: Creating an Integration Project and Importing Knowledgemodules
      • Optional: Creating Simple Interface Example -1
      • Optional-2 Creating Simple Interface Example-2
    • Filter Transformations
      • Simple Filter Transforamtion
      • Optional Creating Filter Transformation Example-1
      • Filter Transformation Examples
      • Optional Creating Filter Transformation Example-2
      • Advanced Filter Transformation
      • Optional Creating Filter Transformation Example-3
    • Join Transformations
      • Inner Join Transformation
      • Optional : Join Transformation
      • Left outer Join Transformation
      • Right Outer Join Transformation
      • Between Join Transforamtion
      • Self Join Transformation
    • Set Operators Transformations
      • Union Transformation
      • Union All Transformation
      • Minus Transformation
      • Intersect Transformation
    • Complex Transformations
      • ODI Pivot: Rows to columns Transformation
      • ODI Pivot: Columns to Rows Transformation
    • Lookups Transformations
      • Creating Lookup Transformations
    • Slowly changing Dimension Transformations
      • Implementing SCD Type-1 Transformations
      • Implementing SCD Type-2 Transformation
    • Aggregation Transformations
      • Handling Group By in ODI
    • Yellow Interfaces in ODI
      • Implemernting subqueries in ODI through yellow interfaces
    • Knowledge Modules
      • Overview of LKM and IKM knowledge Modules in ODI
    • Files and XML Transformations
      • Exporting Delimeter Flat File to RDBMS
      • Exporting Fixed width Flat File to RDBMS
      • Exporting XML to RDBMS
    • Procedures and Packages
      • Creating an ODI Procedure
      • Package Overview
      • Creating Packages in ODI
    • Variables and Complex Package
      • Variables Overview
      • creating loops in ODI Package (Multiple sources single target)
    • Data Quality in ODI
      • Data Quality Introduction
      • Creating constraints in ODI
      • Creating a data quality check interfaces in ODI
    • Change Data Capture
      • Overview and Implementation of change data capture in ODI
    • ODI Run Time Components Installations
      • ODI Run time components overview
      • ODI StandAlone Agent Installation
      • ODI Standalone Agent Installation Video Part1
      • ODI Standalone Agent Installation Video Part2
      • ODI Agents Quiz
    • Scenarios & Load Plans
      • ODI Scenario Overview video
      • Scenarios Overview
      • Generating Scenarios
      • Generate all scenarios in a project
      • Executing and Sceduling a scenario
      • Load Plans Overview
      • Creating Load Plans
      • Executing and Sceduling Load Plans
      • Export all Scenarios
      • Load Plans and Scenarios Quiz
    • ODI Certification Study Guide
      • Practice Test-1
      • Practice Test-2
      • Practice Test-3
    • ODI Interview Questions
      • ODI Interview Questions
    • Conclusion
      • What Next?
      • ODI 11g New Features Link

Course Fee:
USD 199

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top