The blog for Oracle Data Integrator ( ODI )

Information about the ODI Certification Exam

Hi Everyone,

Our reader, Ramanathan Lakshmanan, make us an huge favor in sent me the following comments about the ODI Certification Exam.

He just had taken the exam and here are a general view about the exam content as he saw:


Exam: 1Z1-482-Oracle Data Integrator 11g Certified Implementation Essentials-ENU

The Exam tests you on below Subject Areas and OPN Members can access the relevant Online Courses for these as well from the Oracle OPN Site:

1.      Introduction to ODI

2.      ODI Architecture

3.      ODI Models and Data stores

4.      ODI Project Development

5.      ODI Managing Execution

6.      Oracle Golden Gate with ODI

7.      Doing more with ODI

8.      Enterprise Data Quality with ODI

The Exam has a total of 124 questions and last for a duration of 150 Minutes. The Weightage is as below:

1.      ODI Model, Architecture, KM and Development – 50%

2.      ODI CDC and JKM  – 8%

3.      ODI Load Plans and Execution – 10 %

4.      ODI SDK and ODI Console – 5%

5.      EDQ and ODI– 25%

6.      Golden Gate and ODI – 2%

Also some key areas where repeated questions are coming from are as below:

1.      ODI Model, Architecture, KM and Development

a.       Dependency between physical and logical Entities

b.      Use of Security UI in ODI

c.       How Group By Clause works in Interface

d.      Mapping using Data sets

2.      ODI CDC and JKM 

a.       Naming conventions of Views and Tables created by JKM

3.      ODI Load Plans and Execution

a.       Types of steps

b.      Error Handling

c.       Rerun options

4.      ODI SDK and ODI Console

a.       Can we do Admin tasks with ODI SDK

b.      What can we do from the ODI Console

5.      EDQ and ODI

a.       Types of Parsers

b.      Address Validation related Questions

c.       How does EDQ get invoked from ODI

6.      Golden Gate and ODI

a.       User Parameters to configure OGG in ODI


Thank you very much Ramanathan!!!


Leave a Reply

Required fields are marked *.

This site uses Akismet to reduce spam. Learn how your comment data is processed.