Oracle Data Integrators (ODI)

Oracle Data Integration provides bulk data movement, transformation, synchronization, data quality, data management, and data services to ensure that information is timely, accurate, and consistent across heterogeneous systems. Oracle Data Integration products improved the speed of handling data by 50%, and reduced business process execution times by at least 70%.


Course Content:

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 non generic profiles
 Topology Configuratiuon
 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
 Types of variables
 Use cases of variables in work flow
 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
 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 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 Contraints
 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 work flow
 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 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 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 work around)
 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 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 stratagies.
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 Grovvy within ODI

149826204