Type: Offer Category: Training Price: Contact advertiser

ODI 12c Online Training

Advertiser: FuturePoint Technologies Location: Ameerpet Posted: Jul 12, 2017 4:54:44 AM Hits: 111

ODI 12c Online Training


Ref: CS124397
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
• WCF, WPF, LINQ, AJAX, SILVER LIGHT
• Webservices , SOAP , REST ( JAVA)
• Windows 2012 server
www.futurepointtech.com/odi-training.html

More details: ODI 12c Online Training
On Social:ODI 12c Online Training on facebook/FuturePointTechODI 12c Online Training on twitter/FuturePoint TechnologiesODI 12c Online Training on linkedin/futurepoint-technologiesODI 12c Online Training on pinterest/FuturePoint TechnologiesODI 12c Online Training on gplus/+FuturePointTechHyderabad

Contact Advertiser My Post Inform Friend Report Spam