Pages

ODI 12c Classroom Training in Madhapur

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)

  • SQL
  • PL/SQL

Week Number Topics Covered (2hrs – 1hr Explanation + 1hr Practice)
ODI 12c
1
  1. Introduction to ODI
  2. ODI Architecture
  3. Discussion on Various Navigators
  4. Creating Master & Work Repository
  5. Creating and Managing Topology
  • Physical Architecture
  • Logical Architecture
  • Context
  • Agent
  1. Creating Model
  2. Creating Project
  3. Components palette & Property Inspector
  4. 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
  • Simple
  • Consistent
22. Slowly Changing Dimension
  • Type 1
  • Type 2
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 
 

Facebook Like

Contact Form

Name

Email *

Message *

FaceBook FOLLOW

Total Pageviews