ORACLE DATA INTEGRATOR 11g & 12c: ELT/ETL DEVELOPMENT SELF-STUDY CBT

How This Course Is Organised
The Oracle Data Integrator 11g and 12c : E-L-T/ETL Development Fundamentals 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 11g and 12c  for activities based on real-life work scenarios.

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 and 12c Mappings, 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 and the new Mappings Editor.

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 Integartion and ETL Developers
Business Intelligence Developer
Data Warehouse Administrator
Data Warehouse Analyst
Data Warehouse Developer
Technical Administrator

Course Objectives:

Understand the ETL Development Lifecycle
Understand basic Data warehousing Concepts
Understand basic Dimension Modelling
Understand Data Quality Issues in ETL Process
Understand the ODI architecture and Components
Connect to ODI Master and Work Repositories
Define Data Sources
Define Physical and Logical Architecture
Create and reverse-engineer models
Manage Projects
Define Integration Processes
Work with projects in Oracle Data Integrator and release your work for deployment
Understand models, reverse-engineering model metadata from your database
Manage metadata in Oracle Data Integrator: models and data quality
Create simple and complex interfaces and add multiple sources to an interface
Launch a session to run an interface
Enforce data quality constraints in an interface
Manage packages
Understand Oracle DI Studio 12c New Features
Create Mappings Oracle DI Studio 12c
Create Mappings Using the Model and Topology Objects Wizard
Describe Oracle Data Integrator and Big Data Integration Patterns

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

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

Introduction to Oracle Data Integrator Studio

Graphical Interface

Defining an Interface

Navigating Oracle DI Studio Interface

Defining a Modular Interface

ODI Packages

Load Plans

Agents

Repositories

ODI Console

Exploring Oracle DI Console

Connecting to ODI Master and Work Repositories  

Creating and Connecting to ODI Master Repository  

Creating and Connecting to ODI Work Repository

Setting Up ODI Topology and Concepts

Introduction to Contexts

The Physical Architecture

The Logical Architecture

Logical Architecture and Contexts

Data Servers

Creating Physical Data Servers

Creating Physical Schemas 

Creating Logical Data Servers

Creating Logical Schemas 

Standalone and Java EE Agents

Physical and Logical Agents

Configure Physical Java EE Agents

Creating Logical Java EE Agents

Setting up Load Balancing

Managing Standalone ODI Agents

Starting ODI Agent from Command Line

Examining the Default ODI Parameters File

Testing the ODI Agent

Executing ODI Objects with Agent

Knowledge Modules Concepts

Knowledge Modules at Design and Runtime

Pluggable Knowledge Modules

The Topology Matrix

Working with Contexts

Creating Developer Context

Creating Production Context

Working with Projects

Understanding the Project Life Cycle

Creating a Project

Working with Knowledge Modules

Project and Global Knowlegde Modules

Modules Naming Convention

Loading Knowledge Modules

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

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

Extracting, Transforming and Loading Customer Dimension

Creating the Customer Load Interface

Creating Customer Mappings

Creating Customer Filters

Creating Customer Data Flow

Executing the Customer Interface

Extracting, Transforming and Loading City Dimension

Adding the City Dimension

Creating City Mappings

Creating City Data Flow

Executing the City Interface

Extracting, Transforming and Loading Heterogeneous Sources

Adding Heterogeneous Sources

Creating Heterogeneous Joins

Creating Heterogeneous Mappings

Exploring the Heterogeneous Data Flow

Executing the Heterogeneous Interface

Extracting, Transforming and Loading Fact Tables

Creating Orders Fact

Editing Orders Fact Mappings

Creating Orders Fact Data Flow

Extracting, Transforming and Loading XML Files

Creating the XML Load Interface

Creating the XML Joins

Creating the XML Mappings

Creating the XML Data Flows

Executing the XML Interface

Working with Data Integrity

Checking the Quality of Existing Data

Defining Reference Data Loading Rules

Defining Conditions to Enforce Data Load

Workflow Management

Working with Packages and Scenarions

Creating a Package

Exploring Package Tools

Linking Steps in Package

Creating Notification Message

Executing Package

Compile Package into Scenario

Working with Functions and Variables

Understanding User Functions

Creating a User Functions

Applying the User Function in an Interface

Run the User Function in the Interface

Creating a Variable

Oracle DI Console Administrative Operations  

Performing Operations in ODI Console  

Managing Scenarios and Sessions ODI Console  

Administering Repositories in ODI Console

Oracle Data Integrator 12c

Understand Oracle DI Studio 12c New Features

Exploring the Oracle DI Studio 12c Interface

The Mapping Editor in Studio

Knowledge Module Architecture

Oracle Warehouse Builder Integration

Oracle GoldenGate Integration

Architecture for Enterprise-Scale Deployment

Oracle Data Integrator 12c Fundamentals

Creating ODI Project

Creating Source Dataserver and the Physical Schema

Creating Source Logical Schema

Creating Source Model

Creating Target Dataserver and the Physical Schema

Creating Target Logical Model

Creating Target Model

Exploring the Mapping Editor

Creating ODI Mapping

Introduction to the Model and Topology Objects Wizard

Create Mappings Using the Model and Topology Objects Wizard

Creating Source Data Model

Creating Target Data Model

Creating Diagram based on Source Model

Creating Mapping using Diagram

Generating Code for the Target Platform

Exploring the Data Loading Strategies (LKM)

Running and Monitoring the Mapping

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 E-LEARNING, CBT OR DISTANCE LEARNING FORMATS. FEEL FREE TO ASK IF YOU PREFER DISTANCE, E-LEARNING OR CBT LEARNING  FORMATS. PRICES DIFFER

What is Computer Based Training - CBT?