ODI TRAINING IN BANGALORE

Prerequisites

·  40 GB HD

·  2  GB RAM

·   ORACLE 11G R2

·   Web logic Server 11G

·   ODI 11G

·   RCU 11G

Datawarehousing Concepts:

• Physical and Logical Data modeling
• Creating Physical tables and schemas
• Creating Oracle Queries
• Data base installations
• Dataware house concepts
• Star Schema , Snowflake Schema and Galaxy Schema
• SCD Types  ( slowly changing dimentions)
• Dimentional modeling
• Data modeling
• ODI Installations
• Weblogic Installations and configurations
• Oracle Data Integrator 11G New Features Overview

Course Objectives:

• Overview of the architecture of the complete Oracle Data Integrator system

• Define the Information System architecture

• Get started with projects in Oracle Data Integrator and release your work for deployment

• An overview of models, reverse-engineering model metadata from your database, and how and why to flesh out models with missing metadata

• Manage metadata in Oracle Data Integrator: models and data quality

• Create simple interfaces and add multiple sources to an interface

• Launch a session to run an interface

• Enforce data quality constraints in an interface

• Manage packages

• Add more advanced integration components

• Customize data flow and get the best performance out of your system

• An overview of sessions, use Operator to monitor, stop and start sessions, and basic troubleshooting.

Introduction :  2 Hrs

·  Identifying the Course Content

·  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

 Installations & Configurations : 3Hrs

·  Oracle 11G Database.

·  ODI 11G

·  Weblogic Server 11G

·  Configurations

Administering ODI Repositories and Agents : 3 Hrs

·  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 :  3 Hrs

·  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 : 2 Hrs

·  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 : 2 Hrs

·  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 :  2 Hrs

·  What is a Model?

·  Understanding Metadata in ODI

·  Understanding Reverse Engineering

·  Creating Models

·  Organizing Models

·  Creating Data stores

·  Using Constraints in ODI

·  Creating Keys and References

Organizing ODI Models and Creating Data stores : 2 Hrs

·  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  : 2 Hrs

·  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 : 2 Hrs

·  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 : 1 Hrs

·  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 : 3 Hrs

·  Using Business Rules in Interfaces

·  Overview of Business Rule Elements

·  Using variables

·  Using User Functions

·  Using Substitution Methods

·  Modifying a KM

·  Developing Your Own KM

·  Using RKM for Customized Reverse Engineering

Using ODI procedures : 2 Hrs

·  What is a Procedure?

·  Examples of Procedures

·  Creating Procedures

·  Adding Commands

·  Adding Options

·  Running a Procedure

·  Using Operator to View Results

Using ODI Packages : 2 Hrs

·  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 :  2 Hrs

·  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 : 4 Hrs

·  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 :  2 Hrs

·  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

Administering ODI Resources: Advanced Topics : 3 Hrs

·  Using Open Tools

·  Installing Open Tools

·  Using Open Tools in a Package

·  Using Open Tools in a Procedure or in a KM

·  Developing Your Own Open Tools

·  Setting Up ODI Security

·  Defining Security Policies

·  Defining Password Policies