Type: Offer Category: Training Price: Contact advertiser

ODI Training Course

Advertiser: Sriram Posted: Jan 5, 2019 3:53:02 PM Hits: 209

ODI Training Course

Ref: CBC186644
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
• Build and Release
• CA Siteminder
• CCNA, CCNP Security, CCIE
• Citrix XenApp
• Cognos 10 BI & Tm1
• Crystal Reports
• Data Stage
• 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

More details: ODI Training Course

Contact Advertiser My Post Inform Friend Report Spam