60% Complete Courses » Oracle Data Integration 12C
  • Course Content
  • Course Overview
  • Training Schedule
  • Demo Video
  • Learning Material
  • Register

Course Agenda:

Class: 1 Introduction to ODI
v Identifying the Course Units
v Why Oracle Data Integrator?
v Overview of ODI Architecture
v Overview of ODI Components
v About Graphical Modules
v Types of ODI Agents
v Overview of Oracle Data Integrator Repositories

Class: 2 Installation of ODI 12c
v Identifying the required software’s.
v Prerequisites
v System Requirements
v Installation of ODI
v Repository Configuration using RCU
v Setting the sample database for hands-on

Class: 3 Introduction to ODI Repository and Agents
v Administrating the ODI Repositories
v Connecting to the Master Repository
v Connecting to the Work Repository
v Managing ODI Agents
v Creating a Physical Agent

Class: 4 ODI 12c Features
v The Benefits of Using ODI 12c
v Overview of ODI 12g Architecture and Components
v The features of New ODI 12c User Interface and its Components
v Overview of ODI 12g New Features

Class: 5 ODI Topology Navigator
v Creating Physical Architecture
v Creating a Data Server
v Testing a Data Server Connection
v Creating a Physical Schema
v Creating Logical Architecture
v Overview of Logical Architecture and Context Views
v Linking the Logical and Physical Architecture

Class: 6 ODI Models and datastores
v What is a Model?
v Understanding Metadata in ODI
v Understanding Reverse Engineering
v Creating Models
v Organizing Models
v Creating Data stores
v Configuring Constraints in ODI
v Creating Keys and References

Class: 7 ODI 12c Mapping
v What is a Mapping?
v Designing a Mapping
v Business Rules for Mapping
v What is a Mapping, a Filter, a Join?
v Overview of Integration Process
v What is a Staging Area?
v Execution Location
v Mapping with Knowledge Modules (KM)
v Creating an Intermediate Mapping

Class: 8 ODI 12c MappingMonitoring and Debugging
v Monitoring Mappings
v Creating Objects with Operator
v Viewing Sessions and Tasks
v How to Monitor Execution of a Mapping
v How to Troubleshoot a Session
v Keys to Reviewing the Generated Code
v Working with Errors
v Tips for Preventing Errors

Class: 9 Designing Mappings: 1
v Mapping with Business Rules
v Overview of Business Rule Elements
v Creating and Tracking Variables
v Creating User Functions
v Mapping Substitution Methods
v Showing Variable Values in Log
v Customizing Reverse Engineering Using RKM

Class: 10 Designing Mappings: 2
v Using Partitioning in a Mapping
v Reusable Mappings
v Derived Select (Subselect) for Reusable Mappings
v Using User Functions
v Creating a User Function
v Using Substitution Methods

Class: 11 ODI Procedures
v What is a Procedure?
v Examples of Procedures
v Creating Procedures
v Adding Commands
v Adding Options
v Running a Procedure
v Viewing Results with Operator

Class: 12 ODI Packages
v What is a Package?
v Creating a Package
v Executing a Package
v Creating Advanced Packages
v Error Handling
v Controlling an Execution Path
v Creating a Loop

Class: 13 ODI Scenarios and versions
v What is a Scenario?
v Managing Scenarios with Load Plans
v Preparing Scenarios for Deployment
v Automating Scenario Management
v Scheduling the ODI Scenario
v Overview of ODI version management
v Handling concurrent changes

Class: 14 Enforcing Data Quality
v Why Data Quality?
v When to Enforce Data Quality?
v Data Quality in Source Applications
v Data Quality Control in the Integration Process
v Data Quality in the Target Applications
v Enforcing Data Quality
v Exploring Your Data
v Auditing Data Quality

Class: 15 ODI Changed Data Capture
v Techniques of Changed Data Capture
v Changed Data Capture in ODI
v CDC Strategies and Infrastructure
v CDC Consistency
v Creating Change Data Capture (CDC)
v Viewing Data/Changed data
v Journalizing

Class: 16 Load Plans
v What Are Load Plans?
v Load Plan Editor
v Load Plan Steps
v Defining the Restart Behavior
v Benefits of Using Load Plans
v Handling Failed Load Plans

Class: 17 ODI Security Navigator
v Security Concepts: Overview,
v Defining Security Policies
v Creating Profiles, Creating Users,
v Assigning a Profile to a User,
v Assigning an Authorization by Profile or User
v Defining Password Policies,
v Generating Topology Reports

Class: 18 Step-by-Step Debugger
v Benefits of Using Step-by Step Debugger
v Overview of the Features of Step-by-Step Debugger
v Debugging Mappings using the Debugger
v Debugging Packages using the Debugger

Class: 19 Developing ODI Knowledge Modules
v Overview of Different Types of KMs
v Guidelines for KM Developers
v Working with Substitution Methods
v Applying Various ODI Tags
v Implementing Java in KMs
v Troubleshooting and Debugging KMs

Class: 20 Using Groovy in ODI
v Interacting Programmatically with ODI
v Overview of ODI SDK
v Introduction to Groovy
v Using Groovy Editor
v Automating Development Tasks with Groovy
Course Id:
Course Fees:
301 USD