ODI Training and JobSupport at Futurepoint

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
Disabling Transformations, Overview of the Flow
Specifying the Staging Area. Selecting Knowledge Modules

Mapping execution Monitoring and Debugging
Monitoring Mappings, Creating Objects with Operator, Viewing Sessions , Tasks & troubleshoot
Execution with simulation, working with Errors and tips for Preventing Errors

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)
Working with LKM for Oracle, ANSI SQL, Files, XML
Working with IKM for Oracle, ANSI SQL, Files, XML
Working with data validation through CKM
Customizing Reverse Engineering Using RKM
Implementing CDC in ODI through JKM

Creating and Running ODI procedures
What is a Procedure and examples of Procedures. Creating Procedures
Adding Commands, Options, Running a Procedure and View Results with Operator

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
What is a Scenario? Managing Scenarios with Load Plans. Preparing Scenarios for Deployment
Automating Scenario Management. Scheduling the ODI Scenario
Overview of ODI version management and Handling concurrent changes

Enforcing Data Quality and Auditing Data with ODI
Why Data Quality? When to Enforce Data Quality?
Data Quality in Source Applications, DQ Control in the Integration Process
DQ in the Target Applications, Enforcing DQ, Exploring Your Data and auditing DQ

Working with Changed Data Capture
Techniques of CDC and how to do it in ODI
CDC Strategies and Infrastructure, CDC Consistency. Creating Change Data Capture (CDC)
Viewing Data/Changed data, 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 and Developing Your Own Open Tools
Setting Up ODI Security, Defining Security Policies and Defining Password Policies

Courses Offerings

Amazon Web Services
Android
AIX Administration
Business Analyst
Build and Release
CA Siteminder
CCNA, CCNP Security, CCIE
Citrix XenApp
Cognos 10 BI & Tm1
Crystal Reports
Data Stage
DB2 DBA
Dev Ops
Dot Net
Google Web Tool Kit
Golden Gate
Hadoop
Hyperion Essabase, Planning, HFR , HFM
IBM Websphere Commerce server Admin
IBM Lotus Notes (Development)
IBM Lotus Notes Domino Server Administration
IBM Message Broker
IBM MQ Series Administration
IBM Netezza DBA & Development
IBM Tivoli Access Manager
IBM Web Sphere Application Server Administration (WAS)
IBM Websphere Transformation extender (WTX 8.2)
IBM Integration BUS ( IIB )
Informatica
I Phone
Swift Language training
Java/J2EE
JAVA UI
Java Apache Wicket
Linux Administration training
MicroSoft .NET Technologies (VB.NET, C#, ASP.NET, Wcf ,Wpf ,Mvc)
Microstrategy
MicroSoft Business Intelligence
OBIEE 11 g , 12c
ODI ( Oracle Data Integrator)
Openstack
Oracle APPS HRMS, SCM, Manufacturing , Technical , ASCP .Dmantra
Oracle APPS Project Accounting
Oracle APPS - iProcurement , iSupplier, Sourcing
OAF
Oracle BI Apps
Oracle BI Publisher
Oracle DBA 11g
Oracle RAC , Data Guard , Performance Tuning,
Oracle Fusion SOA
Oracle SQL , PL SQL
PHP
Perl Scripting
Qlikview
RUBY Cucumber
SAP SD , BO , FICO , BI / BW , APO , BPC, BASIS , SRM , MM, ISOil, BODS
SAP Simple Finance
SAS
Sales Force CRM
SharePoint Server 2010
Shell Scripting
Siebel CRM , EAI, E-Scripting
SQL Server DBA
Springs and Hibernate
Storage Area Network ( SAN)
Tableau
Team Foundation Server
Tera Data
Testing Tools - QTP, QC, Load Runner, Selenium, ISTQB
TIBCO BW, BE, TIBCO I Process
Tivoli Access Manager & Tivoli Storage Manager
Unix & Linux Administration
VMWare
WCF, WPF, LINQ, AJAX, SILVER LIGHT
Webservices , SOAP , REST ( JAVA)
Windows 2012 server
http://www.futurepointtech.com/odi-training.html