Oracle ODI

Introduction to Data warehousing
 What Is Data warehousing?
 Who needs Data warehouse?
 Why Data warehouse is required?
 Maintenance of Data warehouse
 Difference between ETL and ELT?
 Advantages and Limitations of ODI
Data warehousing Architecture
 Source
 Integration Layer
 Staging Area
 Targets
 Analysis & Reporting
Oracle Data Integrator 11.1.5
1. Introduction to Topology
 Product Architecture
 Installation / Configuration
 Master & Work Repository Creation
 ODI Support for:
 Technologies
 Data Types
 Languages
 Physical Architecture Topology
 Logical Architecture Topology
 Use of Contexts
2. Introduction to Model
 Standard /Custom Reverse
Engineering
 Checking
 Enforcement
 Change Data Capture
 Browsing Data from within Designer
3. Designer -Introduction
 The ODI Project
 Interface Design
 Execution monitoring
 Debugging & Troubleshooting
 Version Control
 Scenarios and Solutions
 Knowledge Module Design
 Package Workflow Design
4. User Functions -Introduction
 Users
 Profiles
 Privileges
 Scheduling
 Procedures
 Variables
 User Functions
 Sequences
Preparation for Job-search
 Mini-Project
 Validation of Data
 Real-Time Scenario’s
 Resume Preparation
 Interview Preparation