ODI

Course Overview:

In this Oracle Data Integrator (ODI) training provides hands-on experience in configuring and managing the ODI 12c environment. The course covers various techniques and methods of data integration across various platforms based on Extract Load Transform architecture. With instructor-led online classes, the trainee will master advanced ODI concepts such as project development, data integration 12c models, datastores, and much more through the best practices.

Course Content:

Introduction

Oracle Data Integrator Overview

♦Traditional ETL vs ODI ELT

♦ Business use cases

♦ ODI Architecture

♦ Installation overview

ODI Repositories And Agents

♦ Creating Master and Work repositories

♦  Administering repositories

♦ Introduction to Repositories Metadata(SNP tables)

♦ Agents and its configuration(Standalone Agent)

ODI Security and Topology

♦ Custom profiles in security

♦ Creating users with generic and nongeneric profiles

♦ Topology Configuration

♦ Defining any new technology in Topology

♦ Logical and Physical architecture

♦ Setting data server and physical schema

Context and Agents

♦ Defining Flexfields for objects

ODI Variables, functions and procedures

♦ 12Types of variables

♦ Use cases of variables in workflow

♦ User-defined Functions

♦ Native and user-defined sequences

♦ ODI procedures

♦ Global objects (variable,functions,procedures,sequences and KMs)

Knowledge Modules

♦ Six different types of knowledge Modules

♦ Knowledge module customization w.r.t. to business use cases

♦ Technology specific KMs

♦ A brief discussion of KM options and tasks

♦ Introduction to java APIs and their use cases inside KMs.

♦ Creating your own customized KM

♦ Multi connection KM

Models and Constraints

♦ Introduction to Models and Datastore

♦ Defining the ODI model w.r.t. Technology

♦ Model creation through Common format designer

♦ Reverse Engineering

♦ Defining Datastore

♦ ODI specific constraints on Datastore

♦ Partitioning

♦ Generating DDL scripts and Interface IN/OUT

Data Quality Control

♦ Check Constraints

♦ Static and Flow control

♦ Recycle errors

♦ Metadata tables for error diagnostics (SNP tables)

ELT vs ETL

♦ Defining Staging Area

♦ Use cases for defining staging area w.r.t. technology

ODI Operator

♦ Monitoring Integration process

♦ Debugging integration Session and tasks

♦ Restart mechanism

♦ ODI job scheduling

♦ ODI logs and log purge

Packages, Load plans, and Scenarios

♦ Introduction to package workflow

♦ Synchronous and Asynchronous Run

♦ Creating Scenarios for objects

♦ Dynamic value binding in Scenarios

♦ Business use cases for defining flow and scripting

♦ Defining sequence of steps and running a package or scenario

♦ Exception handling inside the package

♦ Introduction to Load plans

♦ Serial and parallel session execution in Load plans

♦ Flow control and exceptional handling in Load plans

ODI Designer

♦ Project and its components

♦ Cross-references of objects in the designer navigator

♦ Knowledge module Import

♦ Markers and Memos

♦ Scope of variables and other objects

Change Data Capture (CDC)

♦ CDC overview and implementation

♦ Static and consistent CDC

♦ Trigger-based CDC

♦ Golden gate CDC

♦ Timestamp based CDC

♦ Journalizing Knowledge module(JKM)

Data warehousing

♦ Data warehousing basics and overview

♦ Datamart

♦ Dimension and Facts

♦ Star and snowflake schemas

Slowly changing Dimension (SCD)

♦ SCD overview

♦ SCD type 1,2 and 3

♦ SCD implementation inside Models

♦ Knowledge Module customization for SCD

♦ Integration of dimension and facts table (end to end cycle)

Interface (Mapping)

♦ Navigation and mapping editor

♦ Mapping creation with multiple targets 12c

♦ Defining LKM, IKM, and CKM inside mapping

♦ Implementation of business logic inside mapping

♦ Defining datasets and lookups

♦ Physical and Logical mapping (12c)

♦ Defining options inside KM

♦ Temporary Interface (11g)

♦ Reusable mapping (12c)

♦ Data warehousing implementation using reusable mapping

♦ Designing ETL vs ELT mapping

ODI components

♦ Overview and implementation

♦ Joins and filters

♦ Aggregation (not available in 11g and its workaround)

♦ Sets (UNION, UNION ALL, MINUS, INTERSECT)

♦ PIVOT and UNPIVOT

♦ Expression

♦ Datasets

♦ Split and sort

♦ Lookup and Distinct

Code Migration

♦ Different techniques for code migration

♦ Smart import and Export

♦ Unique internal Ids and GUID

♦ Unique repositories IDs

♦ Export and Import Hierarchy

♦ Setting up a production environment

Working with Different Technologies

♦ File and table transformations

♦ XML transformations

♦ Working with delimited and fixed file format

Version Controlling

♦ Version controlling

♦ Implementation versions in Solutions

♦ Maintain versions with metadata

♦ External code backup

ODI Tools Reference

♦ Tools guide

♦ Different file Tools

♦ Object related tools

♦ Execution tools

♦ Tool Customization

ODI through Web Services

♦ Introduction to ODI web services

♦ J2EE agent and its advantage

♦ Data services

♦ ODI console

♦ Invoking third party web services

♦ Managing Executions using web services

ODI Performance Tuning

♦ Mapping optimization (data movement reduction)

♦ Runtime optimization(Agent location)

♦ Load balancing

♦ Mapping loading strategies.

Miscellaneous

♦ Integration of Big data and Hadoop in ODI

♦ Integration with NoSQL databases

♦ Implementing Jython code in ODI procedures

♦ Knowledge Module customization complex use cases

♦ Implementation of Java Groovy within ODI.

We can assure a 100% job guarantee and Placement. Contact us for Free - Demo.

.