Sold Out

Oracle Data Integrator ODI 12c Training at FuturePoint

Event Information

Share this event

Date and Time




Aditya Enclave, Ameerpet

Niligi block, 2nd floor , 213/a , ameerpet

Hyderabad, Telangana 500038


View Map

Friends Who Are Going
Event description


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 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 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
  • Webservices , SOAP , REST ( JAVA)
  • Windows 2012 server

Share with friends

Date and Time



Aditya Enclave, Ameerpet

Niligi block, 2nd floor , 213/a , ameerpet

Hyderabad, Telangana 500038


View Map

Save This Event

Event Saved