+91 8142000093 info@tanviinfo.com




Course Duration : 40 Hours
Course Delivery : Classroom, Online, Weekends

Course Content

ODI Course Syllabus
Oracle Data Integrator Course Topics
• Architecture
• Architecture Overview
• What Is Oracle Data Integrator?
• The Oracle Data Integrator Architecture
• Components
• Graphical Modules
• Run-Time Components
Topology Concepts
• Overview of the Topology
• What Is the Topology?
• Data Servers and Physical Schemas
• What Is a Data Server?
• Important Note
• What Is a Physical Schema?
• Properties of Physical Schemas
• The Physical Architecture in Oracle Data Integrator
Connecting to Your Data
• Topology Manager
• What Is the Topology?
• What Topology Manager Contains
• The Physical Architecture View
• Data Servers and Physical Schemas
• Prerequisites for Connecting to a Server

• Creating a Data Server
• Some Examples of Drivers and URLs
Defining the Logical Architecture
• Topology Manager
• Overview of Topology Manager
• Logical Architecture/Context Views
• Defining Contexts
• Defining a Context
• Declaring Logical Schemas and Agents
• Creating a Logical Schema
• Linking the Logical and Physical Architecture
Setting Up a New Project
• What Is a Project?
• Overview of Oracle Data Integrator Projects
• What Does a Project Represent?
• Creating a New Project
• Folders
• What Is a Folder?
• What Is a Knowledge Module?
• Exporting and Importing
Oracle Data Integrator Model Concepts
• What Is a Model?
• The Relational Paradigm
• Relational Model Support in Oracle Data Integrator
• Additional Metadata in Oracle Data Integrator

• Reverse-Engineering
• What Is Reverse-Engineering?
• Methods for DBMS Reverse-Engineering
• Standard Versus Customized Reverse-Engineering
Creating and Reverse-Engineering Models
• What Is a Model?
• What Is Reverse-Engineering?
• Methods for DBMS Reverse-Engineering
• How to Create a Model by Reverse-Engineering
• How to Start the Reverse-Engineering Process
• Selective Reverse-Engineering
Fleshing Out Data Models
• Organizing Models
• What Is a Model Folder?
• Creating a Model Folder
• Organizing Datastores into Sub-Models
• Setting Up Automatic Distribution
• Creating a Datastore in a Model
• Adding Columns to a Datastore
• Constraints in Oracle Data Integrator
Enforcing Data Quality with Oracle Data Integrator
• Why Data Quality
• When to Enforce Data Quality
• Data Quality in the Source Applications
• Data Quality Control in the Integration Process

• Data Quality in the Target Applications
• Business Rules for Data Quality
• From Business Rules to Constraints
• Overview of the Data Quality System
Exploring and Auditing Your Data
• Exploring Your Data
• Displaying the Contents of a Datastore
• Viewing the Distribution of Values
• Analyzing the Contents of a Datastore
• Constructing Business Rules
• Defining Business Rules in Oracle Data Integrator
• Deducing Constraints from Data Analysis
• Auditing Data Quality
Interface Design: One-to-one Interfaces
• Creating a One-to-One Interface
• Creating and Naming a New Interface
• Defining the Target Datastore
• Defining the Source Datastore
• What Is a Mapping?
• Defining the Mappings
• Valid Mapping Types
• Saving the Interface
Interface Design 2
• Multiple Sources & Joins
• Multiple Source Datastores

• Manually Creating a Join
• Advanced Joins
• Types of Joins & Setting Up a Join
• Filtering Data
• Filters in Oracle Data Integrator
• Defining a Filter Manually
Executing and Debugging Interfaces
• How to Execute an Interface
• What Happens at Run Time
• Monitoring Interfaces
• Operator: Viewing the Log
• Sessions, Steps, Tasks: The Hierarchy
• Viewing Sessions and Tasks
• How to Monitor Execution of an Interface
• Troubleshooting a Session
Interface Design
• Essential Concepts in Data Quality
• What Is a Constraint?
• Defining and Enforcing Data Quality
• Overview of the Data Quality System
• Properties of Data Quality Control
• Static/Flow Control Differences
• How to Enforce Data Quality for an Interface
• Differences Between Control Types

Defining Simple Procedures
• What Is a Procedure? & Procedure Examples
• Using Procedures: Overview
• How to Create a New Procedure
• Creating a New Command
• Arranging Steps in Order
• Which Parameters Should be Set?
• Valid Types of Commands
• Types of Options
Variables and Sequences
• What Is a Variable?
• Variable Scope
• Value Persistence: Action Types
• Refreshing a Variable with SQL
• Binding Versus Substitution
• How to Create a Variable Step
• Properties of Sequences
• Using Oracle Data Integrator Sequences in Mappings
User Functions
• What Is a User Function?
• Creating User Functions
• Properties of User Functions
• How to Create a User Function
• Defining an Implementation

• Syntax and Implementations
• Using User Functions
• User Functions at Design Time & Run Time
Package Design 1
• What Is a Package?
• How to Create a Package
• Package Diagram Toolbar
• How to Create an Interface Step
• How to Create an Oracle Data Integrator Tool Step
• A Simple Package
• How to Sequence Package Steps
• Executing a Package
Package Design 2
• Types of Package Steps
• Basic & Advanced Step Types
• How to Create a Procedure Step
• Model, Sub-Model and Datastore Steps
• Models, Sub-Models, and Datastore Steps
• How to Create a Variable Step
• Controlling the Execution Path
• Controlling Execution

Releasing Projects
• What Is a Scenario?
• Properties of Scenarios
• Managing Scenarios
• Generating a Scenario
• Generation Versus Regeneration
• Executing a Scenario from the GUI
• Executing a Scenario from a Project
• Preparing Scenarios for Deployment