Welcome To Eazygurus

ODI Data warehousing

Course Name        :   ORACLE DATA INTEGRATOR Online Training
Duration                 :  35 hrs

0 STUDENTS ENROLLED

    • Introduction
      • What is Oracle Data Integrator?
      • Why Oracle Data Integrator?
      • Overview of ODI 11g Architecture
      • Overview of ODI 11g Components
      • About Graphical Modules
      • Types of ODI Agents
      • Overview of Oracle Data Integrator Repositories
    • Administering ODI Repositories and Agents
      • Administrating the ODI Repositories
      • Creating Repository Storage Spaces
      • Creating and Connecting to the Master Repository
      • Creating and Connecting to the Work Repository
      • Managing ODI Agents
      • Creating a Physical Agent
      • Launching a Listener, Scheduler and Web Agent
      • Example of Load Balancing
    • ODI Topology Concepts
      • Overview of ODI Topology
      • About Data Servers and Physical Schemas
      • Defining the Physical Architecture
      • Defining the Logical Architecture
      • Mapping Logical and Physical Resources
      • Defining Agents
      • Defining a Topology
      • Planning the Topology
    • Describing the Physical and Logical Architecture
      • Overview of Topology Navigator
      • Creating Physical Architecture
      • Creating a Data Server
      • Testing a Data Server Connection
      • Creating a Physical Schema
      • Creating Logical Architecture
      • Overview of Logical Architecture and Context Views
      • Linking the Logical and Physical Architecture
    • Setting Up a New ODI Project
      • Overview of ODI Projects
      • Creating a New Project
      • Using Folders
      • Organizing Projects and Folders
      • Understanding Knowledge Modules
      • Exchanging ODI Objects
      • Exporting and Importing Objects
      • Using Markers
    • Oracle Data Integrator Model Concepts
      • What is a Model?
      • Understanding Metadata in ODI
      • Understanding Reverse Engineering
      • Creating and Organizing Models
      • Creating Data stores
      • Using Constraints in ODI
      • Creating Keys and References
    • Organizing ODI Models and Creating Data stores
      • What is an Interface? Business Rules for Interfaces
      • What is a Mapping?
      • What is a Join?
      • What is a Filter?
      • What is a Constraint?
      • What is a Staging Area?
      • Creating a Basic Interface
    • ODI Interface Concepts
      • What is an Interface?
      • Business Rules for Interfaces
      • What is a Mapping, Filter, Join?
      • Overview of Integration Process
      • What is a Staging Area?
      • About Execution Location
      • Using Knowledge Modules (KM) with ODI Interface Creating a Basic Interface
    • Designing Interfaces
      • Designing an Interface
      • Multiple Source Data stores
      • Creating Joins
      • Filtering data
      • Disabling Transformations
      • Overview of the Flow
      • Specifying the Staging Area
      • Selecting Knowledge Modules
    • Interfaces: Monitoring and Debugging
      • Monitoring Interfaces
      • Using Operator
      • Viewing Sessions and Tasks
      • How to Monitor Execution of an Interface
      • How to Troubleshoot a Session
      • Keys to Reviewing the Generated Code
      • Working with Errors
      • Tips for Preventing Errors
    • Designing Interfaces: Advanced Topics
      • Using Business Rules in Interfaces
      • Using variables
      • Using User Functions
      • Using Substitution Methods
      • Modifying a KM
      • Developing Your Own KM
      • Using RKM for Customized Reverse Engineering
    • Using ODI procedures
      • What is a Procedure?
      • Examples of Procedures
      • Creating Procedures
      • Adding Commands
      • Adding Options
      • Running a Procedure
      • Using Operator to View Results
    • Using ODI Packages
      • What is a package?
      • Creating a package
      • Executing a package
      • Creating Advanced Packages
      • Error handling
      • Controlling an Execution Path
      • Creating a Loop
      • Using the Advanced tab
    • Managing ODI Scenarios and Versions
      • What is a Scenario?
      • Managing Scenarios
      • Preparing Scenarios for Deployment
      • Automating Scenario Management
      • Scheduling the ODI Scenario
      • Overview of ODI version management
      • Using Version Browser and Version Comparison Tool Handling concurrent changes
    • Enforcing Data Quality and Auditing Data with ODI
      • Why Data Quality?
      • When to Enforce Data Quality?
      • Data Quality in Source Applications
      • Data Quality Control in the Integration Process
      • Data Quality in the Target Applications
      • Enforcing Data Quality
      • Exploring Your Data
      • Auditing Data Quality
    • Working with Changed Data Capture
      • Overview of ODI version management
      • Techniques of Changed Data Capture
      • Changed Data Capture in ODI
      • CDC Strategies and Infrastructure
      • CDC Consistency
      • Using CDC
      • Viewing Data/Changed data
      • Using Journalizing

    Key Benefits:

    • Exposure to real time scenarios.
    • Job oriented training program.
    • Training in an enterprise highly focused in recruitment.
    • Resume Preparation and Interview Tips
    • Q & A
    • Mock Interview.

    Course Curriculum

    Course Reviews

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 2 weeks, 4 days

    Advanced Course Search

    Total It Training Portal © Eazygurus. All rights reserved.