Tuesday, March 20, 2012

Oracle Data Integrator Course Content 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 :  
·  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 : 
·  Oracle 11G Database.
·  ODI 11G
·  Weblogic Server 11G
·  Configurations

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 Models
·  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
·  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 : 
·  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
Administering ODI Resources: Advanced Topics : 
·  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

2 comments: