Session : 1 – Oracle Data Integrator Course Topics
- Architecture
- Architecture Overview
- What Is Oracle Data Integrator?
- The Oracle Data Integrator Architecture
- Components
- Graphical Modules
- Run-Time Components
Session : 2 – 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
Session : 3 – 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
Session : 4 – 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
Session : 5 – 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
Session : 6 – 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
Session : 7 – 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
Session : 8 – 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
Session : 9 – 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
Session : 10 – 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
Session : 11 – 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
Session : 12 – 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
Session : 13 – 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
Session : 14 – 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
Session : 15 – 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
Session : 16 – 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
Session : 17 – 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
Session : 18 – 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
Session : 19 – 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
Session : 20 – 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
Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.