ODI
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
Contact: any queries are always welcomed
Please
feel free to mail us : sambasiva@sanaari.net
for demo session call: US Number : 1 484 365 2489
India : 8008814567 (whats app)
