Pr-requisites
-
Java
need to install (JDK 1.7.*)
-
Oracle
need to install (Oracle 11g XE is sufficient)
-
SQL
developer need to install
Languages:
Adding
Advantage (But not mandatory- Basics will be covered in training
part)
|
Week
Number |
Topics
Covered (2hrs – 1hr Explanation + 1hr Practice)
ODI
12c |
1 |
-
Introduction
to ODI
-
ODI
Architecture
-
Discussion
on Various Navigators
-
Creating
Master & Work Repository
-
Creating
and Managing Topology
-
Physical
Architecture
-
Logical
Architecture
-
Context
-
Agent
-
Creating
Model
-
Creating
Project
-
Components
palette & Property Inspector
-
Creating
Mapping with Simple example
|
2 |
Discussion
on Components
-
Filter
-
Split
-
Join
-
Sort
-
Aggregate
-
Distinct
-
Set
-
Lookup
-
Expression
-
Unpivot
-
Pivot
|
3 |
11.Creating
Mapping
-
Table
to Table
-
Flat
File to Table
-
Delimited
File to Table
-
Table
to File
12.
User Functions
13.
Variables
-
Evaluated
Variable
-
Incremental
Variable
-
Refresh
Variable
-
Declare
Variable
-
Set
Variable
14.
Sequences
15.
Procedures
|
4 |
16.
Packages
17.
Scenarios
18.
Load Plans
-
Conditional
Load Plan
-
Serial
Load Plan
-
Parallel
Load Plan
19.
Version Control
20.
Modifying Knowledge Modules
21.
Change Data Capture
22.
Slowly Changing Dimension
23.
Migration
-
Smart
Import and Export
-
Import
and Export of Scenarios
|
5 |
24.
Real time Complex examples
25.
Interview Questions
26.
Real Time Project Overview
|
6 |
Additional
Concepts if needed
Contact: shiva@sanaari.net any queries are always
welcomed Please feel free to mail us for demo session or
call @ 1 484 365 2489
India Number @ 91-99497 14567
WhatsApp : 91 8008814567 |