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