ODI-12C Course Curriculum
Comparison: ETL Vs ELT
ETL Architecture overview
ELT Architecture Overview
ETL Vs ELT
Introduction to ODI
What is Oracle Data Integrator and why to use ODI ?
Overview of ODI 12C & ODI 11g Architecture, ODI 11g vs. ODI 12c and ODI 12c new features
Overview of ODI Components (Studio, Agent, Repository)
About Graphical Modules, ODI Agents and ODI Repositories
Administering ODI Repositories and Agents
Administrating the ODI Repositories. Creating Repository Storage Spaces
Creating and Configuring Master and Work Repositories
Managing ODI Agents and Creating a Physical Agent
Launching a Listener, Scheduler and Web Agent
DESIGNER : ODI Topology Concepts
ODI Studio connectivity to Repository, Overview of ODI Topology
Planning and Physical Topology overview
About Data Servers and Physical Schemas, Overview of Topology Navigator
Physical and Logical Architecture
Defining the Physical Architecture, Data Server and Testing connectivity
Creating Physical schema, configuring Oracle Database, files, XML files, Creating physical agent
Defining the Logical Architecture, Mapping Logical & Physical Resources, Define logical agents
Defining and planning of a Topology
Creating Logical Architecture, Overview of Logical Architecture and Context Views
Linking the Logical and Physical Architecture
Overview of ODI context, Global context, mapping physical logical schemas
ODI Project
Overview of ODI Projects, Creating and Organizing New Projects and Folders
Understanding Knowledge Modules, Exchanging ODI Objects and Sharing Global Objects
Exporting and Importing Objects. Using Markers
ODI Model Concepts
What is a Model? Understanding Metadata in ODI and understanding Reverse Engineering
Creating and organizing Models and Data stores, Using Constraints Keys and References in ODI
Organizing ODI Models and Creating Data stores