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 (Lab setup)
  • 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