START THE DAY SMART. LEARN AND SKILL UP - MOVE ON & EARN MORE..

HONE YOUR SKILLS AND UPGRADE YOUR STATUS AND INCOME. EARN MINIMUM £60K WITH YOUR ORACLE DI 12c  ADMINISTARTION AND ETL/ELT DEVELOPMENT SKILLS.

VERY GOOD HANDS-ON INTERACTIVE TRAINING MATERIAL (COMPUTER BASED TRAINING - CBT) WITH EXCELLENT SIMULATIONS USING REAL-LIFE BASED SCENARIOS. PACKED WITH TASKS, ACTIVITIES AND EXERCISES.

PERFECT INTERACTIVE SELF-TEACH TRAINING COURSE FOR THOSE PREPARING FOR ORACLE DATA INTEGRATOR, MDM, BIG DATA, DATA WAREHOUSING, BUSINESS INTELLIGENCE  APPLICATIONS AND PERFORMANCE MANAGEMENT CERTIFICATION EXAMS AS WELL AS THOSE WHO WORK WITH OTHER ETL AND WAREHOUSE TOOLS OR WISH TO UPSKILL TO AN ORACLE DATA INTEGRATOR 11g ENVIRONMENT.


ALSO GOOD FOR ODI VERSION 11.x  ENVIRONMENTS


ORACLE DATA INTEGRATOR 12c (ODI 12c): ADMINISTRATION & INTEGRATION SELF-STUDY CBT

How This Course Is Organised

The Oracle Data Integrator 12c: Administration and Integration course provides step-by-step instructions on how to perform a variety of Data Integration and E-L-T (Extract, Load and Transformation) tasks using Data Integrator 12c for activities based on real-life work scenarios.


Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services. Oracle Data Integrator's Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process and transform the data - the approach that optimizes performance, scalability and lowers overall solution costs.
 

Using the graphical interfaces, you create and manage ODI repositories, which stores configuration information about the IT infrastructure, the metadata for all applications, projects, models and other ODI artifacts. You also learn how to create the ODI Topology, organise ODI models and design ODI interfaces, procedures, packages and other objects.

 

You will learn how to use Oracle Data Integrator Topology Manager to define context and logical schema objects according to current best practices. You will learn how to use manage projects in Oracle Data Integrator to develop interfaces and other objects. You will also learn about the types of metadata, and how to retrieve it automatically from your database.

 

You will learn how to create an integration process, using Oracle Data Integrator packages. This course takes you through some of the more advanced features and uses of Oracle Data Integrator interfaces.


The WebLearning hands-on series reduces the time spent investigating what steps are required to perform a task. Because the step-by-step solutions are built for practical real world situations, not only is knowledge gained through valuable hands-on experience, but also the solutions presented may then be used as the foundation for production implementation, dramatically reducing time to deployment.

.

 

Audience
Data Integration Architects
ETL Developers
Data Warehouse Developers
Data Scientists
Data Warehouse Administrators
Database Administrators
Business Analysts
Technical Consultants
Data Modelers




Course Objectives

Understand the ETL Development Lifecycle

Understand basic Data warehousing Concepts
Understand basic Dimension Modelling
Understand Data Quality Issues in ETL Process
Describe the architecture of Oracle Data Integrator 12c
Apply ODI Topology concepts for data integration
Define Data Sources
Define Physical and Logical Architecture
Learn to ODI Manage Projects
Describe ODI Model concepts
Create and reverse-engineer models
Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations
Explore, audit data, and enforce data quality with ODI
Implement Changed Data Capture with ODI
Enforce data quality constraints in an interface
Manage packages
Understand how to Use ODI Web services and perform integration of ODI with SOA.
Understand how to Extend ODI to include the Big Data Hadoop ecosystem



Course Topics

Overview
Course Scenario
Understanding ETL and Data Integration Platforms
ETL Framework and Components
The Evolution of ETL
Code Generators versus Engines
Database-Centric ETL

Data Integration Platforms
ETL versus EAI
Understanding the Data Integration Tool Market
Functional Capabilities of Data Integration Tools

ODI Value Proposition
Why Oracle Data Integrator?
Traditional ETL to Integration and Data Warehousing
Conventional ETL Design
The ELT Approach to Integration and Data Warehousing
Declarative Design
Traditional ETL versus E-LT Approach

Introduction to Oracle Data Integrator
Oracle Data Integrator Product Architecture
Knowledge Modules
Data Quality
Data Integrity
Name and Address Cleansing Tools
Changed Data Capture
Oracle Data Integrator and Oracle SOA Suite
Oracle Data Integrator in Relation to Oracle Warehouse Builder

Oracle Data Integrator Architecture and Components
Overview of Oracle Data Integrator Repositories
Types of ODI Agents
Stand alone vs J2EE Agents
Overview of ODI Architecture
Knowledge Module Architecture
Oracle Warehouse Builder Integration
Oracle GoldenGate Integration
Architecture for Enterprise-Scale Deployment
About Graphical Modules
Exploring the Oracle DI Studio 12c Interface
The Mapping Editor in Studio

Installing Oracle Data Integrator 12c
Planning the Installation
Installation Options
Standard Installation
Configuring ODI Repositories using RCU
Enterprise Installation

Administering ODI Repositories and Agents
Creating a Wallet to Securely Store Credentials
Administrating the ODI Repositories using Studio
Creating Repository Storage Spaces
Creating and Connecting to the Master Repository
Creating and Connecting to the Work Repository

Managing ODI Agents
Integration of ODI in Enterprise Environment
Using Common Administration Model (CAM)
Methods of Integration of ODI in Enterprise Environment
Configuring ODI Agents using Common Administration Model

ODI Topology Concepts
Overview of ODI Topology
Defining a Topology
Planning the Topology
About Data Servers and Physical Schemas
Mapping Logical and Physical Resources
Defining the Logical Architecture
Defining Agents
Defining the Physical Architecture

Describing the Physical and Logical Architecture
Creating Logical Architecture
Testing a Data Server Connection
Overview of Logical Architecture and Context Views
Creating a Physical Schema
Creating Physical Architecture
Creating a Data Server
Overview of Topology Navigator
Linking the Logical and Physical Architecture

Introduction to ETL Development
The Planning and Design Thread
The Data Flow Thread
Data Delivery Thread

ETL Data Structures
ETL and Data Staging
Designing the Staging Area
Data Structures in the ETL System
Flat Files
XML Data Sets
DTDs, XML Schemas, and XSLT

Relational Tables
Independent DBMS Working Tables
Third Normal Form Entity /Relation Models
Non-relational Data Sources
Dimensional Data Models
Fact Tables
Dimension Tables
Atomic and Aggregate Fact Tables
Surrogate Key Mapping Tables
Impact Analysis
Metadata Capture
Naming Conventions
Auditing Data Transformation Steps
Summary

Oracle ETL-ELT Reference Architecture
Information Architecture Capabilities
Information Provisioning
Data Processing
Data Governance
Data Virtualisation
Information Delivery
Information Access
Information Modelling

Approach to Oracle ETL development
Strategy and Planning Phase
Discover Phase
Analyse Phase
Define Phase
Develop Phase
Deploy Phase

Understanding the Extract, Transform and Integration Process
Data Extraction
The Logical Data Map
Building the Logical Data Map
Approach to Analysing ER Diagrams
Data Content Analysis
Collecting Business Rules in the ETL Process

Integrating Heterogeneous Data Sources
Challenge of Extracting from Disparate Platforms
Processing Fixed Length Flat Files
Processing Delimited Flat Files
Data Transformation
Data Capture

Cleansing and Conforming
Data Cleansing Techniques
Data Conditioning
Data Integration
Data Refining

Data Quality Assessment
Anomalies in Data Fields
Lack of Data Standards
Lack of Data Consolidation

Setting Up a New ODI Project
Overview of ODI Projects
Creating and Maintaining Folders
Creating and Labeling with Markers
Exporting and Importing Objects
Creating a New Project
Understanding Knowledge Modules
Exchanging ODI Objects and Sharing Global Objects
Organizing Projects and Folders

Oracle Data Integrator Model Concepts
Creating Data stores
Organizing Models
Understanding Metadata in ODI
What is a Model?
Creating Models
Creating Keys and References
Understanding Reverse Engineering
Configuring Constraints in ODI

Organizing ODI Models and Creating Data stores
What is a Filter?
What is a Constraint?
Creating a Basic Mapping
Business Rules for Mappings
What is a Mapping?
What is a Join?
What is a Staging Area?

ODI Mapping Concepts
Mapping with Knowledge Modules (KM)
Execution Location
Creating an Intermediate Mapping
What is a Staging Area?
What is a Mapping, a Filter, a Join?
What is a Mapping?
Overview of Integration Process
Business Rules for Mapping

Designing Mappings
Creating Joins
Filtering Data
Multiple Source Data stores
Designing a Mapping
Overview of the Flow
Selecting Knowledge Modules
Disabling Transformations
Specifying the Staging Area

Mapping: Monitoring and Debugging
How to Troubleshoot a Session
Tips for Preventing Errors
Monitoring Mappings
Keys to Reviewing the Generated Code
Working with Errors
Viewing Sessions and Tasks
How to Monitor Execution of a Mapping
Creating Objects with Operator

Using ODI Procedures
What is a Procedure?
Adding Commands
Examples of Procedures
Viewing Results with Operator Navigator
Running a Procedure
Adding Options
Creating Procedures

Using ODI Packages
Variable Steps
Controlling the Execution Path
Error Handling
Review of Package Steps
Executing a Package
What is a Package?
Creating Model, Submodel and Datastore Steps
Creating a Package

Step-by-Step Debugger
Menu Bar Icons
Screen Step Numbering
Control Execution Flow
Specifying Debug Properties
New Functionality
Starting a Session in Debug mode

Managing ODI Scenarios
Generating a Scenario
What is a Scenario?
Scheduling the ODI Scenario
Managing Schedules
Executing a Scenario
Automating Scenario Management

Using Load Plans
Defining the Restart Behavior
What Are Load Plans?
Load Plan Editor
Load Plan Steps
Benefits of Using Load Plans
Handling Failed Load Plans

Enforcing Data Quality with ODI
Why Data Quality? When to Enforce Data Quality?
Data Quality in Source Applications
Enabling Static or Flow Control for a Mapping
Data Quality Business Rules
Data Quality Control in the Integration Process
Data Quality in the Target Applications
Setting the Options, Selecting Which Constraints to Enforce
Reviewing Erroneous Records

Working with Changed Data Capture (CDC)
Journalizing
Oracle GoldenGate Integration
Changed Data Capture in ODI
Viewing Data/Changed data
CDC Strategies and Infrastructure
Why Changed Data Capture? Techniques of Changed Data Capture
CDC Consistency
Creating Change Data Capture (CDC)

Advanced ODI Administration
Integration of ODI with Enterprise Manager
Oracle DI Console Administrative Operations
Create Credential Store for Enterprise Manager
Exploring Oracle DI Console
Testing a Data Server
Testing Physical Agent Connection
Adding a Data Server to a Physical Agent
Creating Templates for Physical Agents
Load Balancing Agents

Performing Operations in DI Console
Exploring Design Time Objects
Eploring Topology Objects
Viewing an Object
Editing an Object
Creating an Object
Searching for an Object
Deleting for an Object

Managing Scenarios and Sessions in ODI Console
Exporting a Scenario
Running a Scenario
Restarting a Session
Cleaning stale Sessions

Administering Repositories in ODI Console
Creating a Repository Connecton
Exporting Repositiries
Exporting Physical Topologies

Oracle Data Integrator and Big Data
Big Data and Hadoop Essentials
Hive Overview
Oracle Big Data Fundamentals
Describe the Oracle approach to Big Data
Oracle Data Integrator and Big Data
Oracle Data Integrator Application Adapter for Hadoop
Loading Unstructured Data from File into Hive
Transforming and Validating Data on Hive
Loading Processed Data in Hive into Oracle




NOTE: THIS COURSE IS ALSO AVAILABLE IN SELF-STUDY CBT FORMAT OR DISTANCE LEARNING. FEEL FREE TO ASK IF YOU PREFER DISTANCE LEARNING OR CBT. PRICES DIFFER


What is a CBT?

CBT's are usually interactive with Software Simulations (behaves like you're using the real thing on the PC, therefore you don't even need the real software installed on your machine) and sometimes BUT NOT ALWAYS with voice. This Publisher's CBTTitles do NOT have voice.


Generally, CBT's tend to be more expensive. Our CBT Titles are NOT based on Flash. They are based on the latest technology which uses the: See It, Do It, and Try It learning paradigm. A very powerful new way of learning. All CBT and Courseware Learning formats are delivered with FULL LICENCE KEY.


Today's competitive business environment and frequent software updates by software vendors demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality Interactive Self-Study in CBT format. These factors give CBT's a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods.


CBT's not only offers the advantage in terms of convenience and lower cost, but it also facilitates improved subject-matter comprehension.


NOTE:WebLearning Publishing CBT and Courseware products are now delivered with FULL LICENCE KEY.

The WebLearning unique Methodology

All WebLearning® CBT and Courseware courses are based on the latest materials available at the time of publishing and are regularly updated every 3 months with FREE UPGRADES to the LATEST EDITION: ANEW, very effective and proven way of learning. 

FACT:

·        Material retention with CBT’S are 45% better than with conventional training methods

·        Your learning curve with CBT is 25%-55% less than conventional methods

·        The cost of CBT training is over 65% less than Classroom training

·        CBT’S are self pacing, interactive and simulate the actual software being studied