ODI(Oracle Data Integrator) Training Institute

Course Duration : 25 Hrs

ODI 12C Course Content

INTRODUCTION TO DATA WAREHOUSING

• Data warehouse concept
• Differences between Online Transaction Processing and data warehouse
• Types of Data Warehouse
• Data warehouse Architecture
• Difference between Data warehouse & Data mart
• Data Warehouse Approaches
• Data Warehouse Components
• Logical & physical Design
• Operational data sources(ODS)

MODELLING FOR DATA WAREHOUSE

• Fact Table
• Dimension tables and types
• Data Warehouse Schemas: Star schema and Star Query, star flake schema, snow flake schema and Galaxy Schema

ODI ( Oracle data integrator ) Installing ODI and Configuration Introduction

• What is ODI
• Why ODI
• Overview of ODI 12c Architecture
• Overview of ODI 12c Components
• Types of ODI Agents
• ODI Repositories
• Creating and connecting to the Master Repository
• Creating and connecting to the Work Repository
• Managing ODI Agents

ODI Topology Concepts

• Overview of ODI Topology
• About Data Servers, Physical and logical schemas
• Creating a Data Server
• Defining the physical and logical architecture
• Creation of Context
• Linking the physical and Logical architecture
• Defining Agents, Topology

ODI Project

• Creation of Project
• Creation of Folders
• Creation of Models
• Reverse Engineering the metadata
• Creating the Datastores
• Knowledge Module (KM)
• Importing the Knowledge modules

ODI Mapping

• Creation of Mapping
• Defining the source and Target datastore
• Different types of components

ODI Components

• What is a Filter
• What is a Join
• What is a Lookup
• What is Constraint
• Staging Area
• Real time Examples with above each component

ODI Procedures

• What is Procedure
• Creating the Procedures
• Adding Commands
• Adding options
• Executing a procedure
• Viewing the results

ODI Package

• What is a Package
• Creating the Package
• Executing the package
• Controlling the execution path
• Creating a Loop
• Using the advanced tab

ODI Scenarios

• What is a Scenario
• Managing Scenarios
• Preparing Scenarios for deployment
• Scheduling the ODI Scenario

ODI Load plan

• What is a Load plan
• Creating the Load plan
• Adding the scenarios to Load Plan
• Error handling in load plans

ODI Version Management

• What is a Version
• Using version browser and version comparison

ODI Variables and Sequences

• Creation of Variable
• Usage of Variable in mapping
• Creation of Sequence
• Usage of sequence in mapping

ODI Project Deployment

• Project Deployment
• Exporting and Importing the projects