ODI Certification Exam syllabus

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