Type: Offer Category: Training Price: Contact advertiser

Oracle Data Integrator ODI 12c Training Course

Advertiser: FuturePoint Location: Mumbai Posted: Jan 27, 2018 2:16:03 PM Hits: 128

Oracle Data Integrator ODI 12c Training Course

Ref: MUC163374
ODI-12C Course Curriculum

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

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
• Team Foundation Server
• Tera Data
• Testing Tools - QTP, QC, Load Runner, Selenium, ISTQB
• Tivoli Access Manager & Tivoli Storage Manager
• Unix & Linux Administration
• VMWare
• Webservices , SOAP , REST ( JAVA)
• Windows 2012 server

More details: Oracle Data Integrator ODI 12c Training Course
On Social:Oracle Data Integrator ODI 12c Training Course on facebook/FuturePointTechOracle Data Integrator ODI 12c Training Course on twitter/FuturePoint TechnologiesOracle Data Integrator ODI 12c Training Course on linkedin/futurepoint-technologiesOracle Data Integrator ODI 12c Training Course on pinterest/FPtechOracle Data Integrator ODI 12c Training Course on gplus/+FuturePointTechHyderabad