Pages

ODI Development Online Training in Hyderabad

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)
 


Facebook Like

Contact Form

Name

Email *

Message *

FaceBook FOLLOW

Total Pageviews