Offer | Need | All

ODI 12c Certificate Oriented Training -USD 500,038

Publish Date: 12-07-2018 08:13:10 | Contact name: FuturePoint Technologies | Location: SINGAPORE | Place: Hyderabad | 1 times displayed |

ODI-12C Course Curriculum

Comparison: ETL Vs ELT

Ø ETL Architecture overview

Ø ELT Architecture Overview


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,

Ø About Graphical Modules, ODI Agents and ODI

ODI Repositories and Agents

Ø Administrating the ODI Repositories. Creating
Repository Storage Spaces

Ø Creating and Configuring Master and Work

Ø Managing ODI Agents and Creating a Physical Agent

Ø Launching a Listener, Scheduler and Web Agent

: 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

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


Ø 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

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,

Ø 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

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

Ø 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

Ø 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,

  • 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

  • IBM Lotus Notes Domino
    Server Administration

  • IBM Message Broker

  • IBM MQ Series Administration

  • IBM Netezza DBA &

  • IBM Tivoli Access

  • IBM Web Sphere
    Application Server Administration (WAS)

  • IBM Websphere Transformation extender (WTX 8.2)

  • IBM
    Integration BUS ( IIB )

  • Informatica

  • I Phone

  • Swift Language

  • Java/J2EE


  • Java Apache Wicket

  • Linux Administration

  • MicroSoft .NET
    Technologies (VB.NET, C#, ASP.NET, Wcf ,Wpf ,Mvc)

  • Microstrategy

  • MicroSoft Business

  • OBIEE 11 g , 12c

  • ODI ( Oracle Data Integrator)

  • Openstack

  • Oracle APPS – HRMS, SCM, Manufacturing , Technical ,
    ASCP .Dmantra

  • Oracle APPS – Project

  • 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,

  • SQL Server DBA

  • Springs and Hibernate

  • Storage Area
    Network ( SAN)

  • Tableau

  • Team Foundation Server

  • Tera Data

  • Testing Tools - QTP, QC, Load Runner, Selenium, ISTQB


  • Tivoli Access Manager
    & Tivoli Storage Manager

  • Unix & Linux

  • VMWare


  • Webservices , SOAP , REST ( JAVA)

  • Windows 2012 server

    | Report bad use or Spam

Contact FuturePoint Technologies: ODI 12c Certificate Oriented Training

Phone: 9247765590




Send me an email with links to manage my Ad

Related Ads

Stay Ahead With The Best Essay Writing Service In U.S offer Professional Courses

Stay Ahead With The Best Essay Writing Service In U.S

Professional Courses - - USD 1

Over the last decade, MyAssignmentHelp essay writing service has provided custom essays to students studying in every academic field. So stay ahead now with our service and get the best grades to top...

Aptech Janakpuri Offering English Training Courses  offer Professional Courses

Aptech Janakpuri Offering English Training Courses

Professional Courses - - INR 15,000

Aptech Janakpuri Institute for English Language is undoubtedly best-known leading institution where one can learn highest values of modern day communication from the best teachers. Our uniqueness l...

Best Digital Marketing Courses in Delhi|Aptech Janakpuri offer Professional Courses

Best Digital Marketing Courses in Delhi|Aptech Janakpuri

Professional Courses - - INR 15,000

Digital Marketing refers how to the promote and advertise of services and products of various manufacturers the usage of one or multiple digital mediums and channels that assist the agency to research...

Interior Designing in Nagpur offer Professional Courses

Interior Designing in Nagpur

Professional Courses -

IIDT is one of the best Interior designing and fashion designing college in Nagpur. Our Institute provide experienced teaching staff for the best results. For more visit Interior Designing in Nagpur....

Best Animation Institute offer Professional Courses

Best Animation Institute

Professional Courses - - USD 1

ANIMATION is a fast-emerging high paying career option. It is extensively used by many organizations like Animation, Studio, Post production studios, advertising firms, Gaming companies, Television Ch...

Best Makeup Course in India |Lakme Academy offer Professional Courses

Best Makeup Course in India |Lakme Academy

Professional Courses - - INR 15,000

The beauty business is growing at a phenomenal pace in India. A large number of leading worldwide brands are eyeing to enter the Indian market. Join the Makeup Artist /Hair Artist Cosmetology cour...

Free Pass Cisco 400-151 Exam with Valid 400-151 Exam Question Answers - offer Professional Courses

Free Pass Cisco 400-151 Exam with Valid 400-151 Exam Question Answers -

Professional Courses -

A best opportunity has been provided to pass your CCIE Data Center Written Exam v2.0 by preparing from 400-151 that has pushed many students to pass their Free 400-151 Dumps. Experienced field experts...

GROW YOUR BUSINESS offer Professional Courses


Professional Courses -

BEST CLASSIFIED SITE IN WORLDWIDE Post Free Advertise in Worldwide And Connect friends, family and other Worldwide people Live chat Example Visit at Click on ...

Advanced Java Training Kerala offer Professional Courses

Advanced Java Training Kerala

Professional Courses -

Learn advanced java training in kerala how and where to use Java without any programming knowledge till now. It will be teach by real time experienced professionals. With our Java training you can rea...

Free 300-320  Dumps | Free 300-320  Exam Study Material - Get Updated 300-320  Real Exam Dumps offer Professional Courses

Free 300-320 Dumps | Free 300-320 Exam Study Material - Get Updated 300-320 Real Exam Dumps

Professional Courses -

If you thoroughly study 300-320 braindumps then you are guaranteed for your success in the final IT test. Although, 300-320 exam is not an easy IT certification but the materials has been designed so ...