500038.00 Dollar US$ Odi 12c Training course at Futurepoint Hyderabad

ODI-12C Course Curriculum

Comparison: ETL Vs ELT
 ETL Architecture overview
 ELT Architecture Overview
 ETL Vs ELT

Introduction to ODI
 What is Oracle Data Integrator and why to use ODI ?
 Overview of ODI 12C & ODI 11g Architecture, ODI 11g vs. ODI 12c and ODI 12c new features
 Overview of ODI Components (Studio, Agent, Repository)
 About Graphical Modules, ODI Agents and ODI Repositories

Administering ODI Repositories and Agents
 Administrating the ODI Repositories. Creating Repository Storage Spaces
 Creating and Configuring Master and Work Repositories
 Managing ODI Agents and Creating a Physical Agent
 Launching a Listener, Scheduler and Web Agent

DESIGNER : ODI Topology Concepts
 ODI Studio connectivity to Repository, Overview of ODI Topology
 Planning and Physical Topology overview
 About Data Servers and Physical Schemas, Overview of Topology Navigator

Physical and Logical Architecture
 Defining the Physical Architecture, Data Server and Testing connectivity
 Creating Physical schema, configuring Oracle Database, files, XML files, Creating physical agent
 Defining the Logical Architecture, Mapping Logical & Physical Resources, Define logical agents
 Defining and planning of a Topology
 Creating Logical Architecture, Overview of Logical Architecture and Context Views
 Linking the Logical and Physical Architecture
 Overview of ODI context, Global context, mapping physical logical schemas

ODI Project
 Overview of ODI Projects, Creating and Organizing New Projects and Folders
 Understanding Knowledge Modules, Exchanging ODI Objects and Sharing Global Objects
 Exporting and Importing Objects. Using Markers

ODI Model Concepts
 What is a Model? Understanding Metadata in ODI and understanding Reverse Engineering
 Creating and organizing Models and Data stores, Using Constraints Keys and References in ODI

Organizing ODI Models and Creating Data stores
 What is a Mapping how to create a mapping in ODI. ODI 12c mappings Vs ODI 11g interfaces
 Business Rules for Mappings
 Creating a Mapping using components : Join, Filter, Switch, Lookup, Aggregate, datasets, Distinct, Expression, Sort, Constraint
 Designing mappings with multiple targets, Mapping Logical and Physical diagram overview
 What is a Staging Area and Work schema

Overview of Integration Process
 Integration Types - Control Append, Incremental Update, SCD
 About Execution Location, Knowledge Modules (KM) overview, Types of knowledge modules
 Using knowledge modules with ODI Mappings

Designing Mappings
 Designing a Mapping with multiple Source Data stores, Creating Joins and Filtering Data

Mapping execution Monitoring and Debugging

Designing Mappings: Advanced Topics
 Mapping with Business Rules and Working with re-usable mappings, multiple files
 Creating and Tracking Variables. Showing Variable Values in Log
 Creating User Functions, Mapping Substitution Methods
 Working with Standard, Native and Specific sequences. Resetting sequences

Working with KM (Knowledge Modules)

Creating and Running ODI procedures

Creating and Running ODI Packages
 What is a Package and how to create and execute a Package
 Creating Advanced Packages, Error Handling, Controlling an Execution Path
 Creating a Loop, Using the Advanced tab

Managing ODI Scenarios and Versions

Enforcing Data Quality and Auditing Data with ODI

Working with Changed Data Capture

Administering ODI Resources: Advanced Topics


http://www.futurepointtech.com/odi-training.html

Share