Oracle ODI Training

• 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

• What Is a Project?

• Overview of Oracle Data Integrator Projects

• What Does a Project Represent?

• Creating a New Project

• What Is a Folder?

• What Is a Knowledge Module?

• Exporting and Importing

What Is a Model?

• The Relational Paradigm

• Relational Model Support in Oracle Data Integrator

• Additional Metadata in Oracle Data Integrator

• 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

• What Is a Model Folder?

• Creating a Model Folder

• Organising Datastores into Sub-Models

• Setting Up Automatic Distribution

• Creating a Datastore in a Model

• Adding Columns to a Datastore

• 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

• 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

• Analysing the Contents of a Datastore

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• Properties of Scenarios

• Managing Scenarios

• Generating a Scenario

• Generation Versus Regeneration

• Executing a Scenario from the GUI

• Implementing a Scenario from a Project

• Preparing Scenarios for Deployment