Welcome
  • Introduction
  • Why Data Integrator?
  • Quiz: ODI Basics
ODI Architecture
  • Development Process Flow
  • ODI Data Flow Architecture
  • ODI Repositories
  • ODI Agents
  • Quiz: Architecture
ODI 12c Virtual Box
  • ODI 12c VM-Introduction
  • 7zip download
  • Changes to ODI12c VM
  • Install ODI12c Virtual Machine (VM)
  • VM Network Configuration
  • Sharing folder between Host Machine and Virtual Machine
  • Start ODI 12c VM
ODI Studio
  • ODI Studio -Introduction
  • ODI Studio- Introduction, Model & Mapping
  • ODI Studio-Procedure
  • ODI Studio-Package
  • Quiz: ODI Studio
Project 1: Customer Data Integration
  • Project 1: Introduction and Importing Flat Files
  • Project1- Lookup
  • Project1-Join
  • Project1-Target Expression
  • Project1-Event Based Target Expression
  • Project1-Knowledge Modules
  • Quiz: Mapping
Project 2- Sales Data Integration
  • Project2-Introduction
  • Project2-Filter
  • Project2-Aggregate
  • Project2-Knowledge Modules
Project3: Data Quality Control
  • Data Quality Control- Introduction
  • Data Quality Control - Implementation
Project 4: Package and Scenario
  • Package
  • Scenario
  • Package and Scenario
Scenario Scheduling
  • Schema Upgrade (optional)
  • Standalone Agent
  • Logical Agent
  • Scenario Scheduling
Project 5: ODI Variables
  • Introduction-ODI Variable
  • Create FTP Server
  • Create ODI Variables
  • Create Package with Variable
  • Variable as Scenario Parameter
Project 6: Complex File
  • Complex File: Introduction
  • Data flow from complex file to data store
  • XML Schema Definition (XSD)
  • Physical and Logical Schemas
  • How to Unhide Technology in Topology
  • Reverse Engineer XML Schema Tables
  • Review Model Data
Project 7: Knowledge Module Customization
  • Built-in Knowledge Modules
  • Knowledge Module Usage
  • Substitution API & Substitution Method
  • Create Knowledge Module
  • Quiz: Knowledge Modules
Project 8: Change Data Capture & Journalizing Knowledge Module
  • Welcome to CDC and JKM
  • CDC and JKM Explanation-1
  • Change Data Capture Subscribers
  • Enabling Change Data Capture
  • Enable CDC and Journalizing on Model and Table
  • Data Flow in CDC
  • CDC Quiz
Project9: ODI and Web Services (REST API)
  • Welcome to section
  • Restful Services
ODI with Hadoop Big Data
  • Introduction
  • Big Data Lite Virtual Appliance
  • Project Introduction
  • Start Services
  • HIVEQL through SQL Developer
  • HIVE Technology in ODI Topology
  • ODI Mapping with Data from Hadoop
Project 10: Load Plan
  • Load Plan Creation
  • Load Plan Execution Monitor
Component Migration
  • ODI Component Migration Introduction
  • Export the components from source instance
  • Import in Target Instance
Let's Install your own ODI
  • Installation-Introduction
Oracle Databse Express Edition Installation
  • Oracle Database Express Edition Installation
  • SQL Developer Download