Oracle Data Integrator 11g Certified Implementation Exam Essentials

Oracle Data Integrator 11g Certified Implementation Essentials

The Oracle Data Integrator 11g Essentials (1Z0-482) exam is designed for individuals who possess a strong foundation and expertise in selling and implementing Oracle Data Integration 11g solutions. This certification covers topics such as: Introduction to Oracle Data Integrator (ODI), Architecture Overview, Models and Datastores, Project Development, Managing Execution, Integration with Oracle GoldenGate (OGG), ODI Software Development Kit (SDK), Enterprise Data Quality (EDQ) Profiling & Batch Processing. This certification differentiates candidates in the marketplace by providing a competitive edge through proven expertise. Up-to-date training and field experience are recommended.

Successfully completing the requirements of this certification track earns the designation of Oracle Data Integrator 11g Certified Implementation Specialist. This certification differentiates OPN members in the marketplace by providing a competitive edge through proven expertise. This certification helps the OPN member's partner organization qualify for the Oracle Data Integration 11g Specialization Criteria.

Exam Number:
2 hours
Exam Price:
US$ 245

More on exam pricing
Number of

Oracle Data Integrator 11g Certified Implementation Specialist.

OPN Certified Specialist.


Beta exam score reports will be available approximately 11 weeks after the close of the Beta Exam (on December 7, 2013). Beta participants will receive an email from PearsonVue with instructions on how to access their exam score.

Passing score subject to change. View Details
Exam Validation:
Exam validated against release 11g
Exam Format:
Multiple Choice


Recommended Training Additional Information & Resources Exam Topics Fraudulent Activity Policy

Recommended Training
OPN Guided Learning Path
Oracle Data Integrator 11g Certified Implementation Specialist
OPN Exam Study Guide
Oracle Data Integrator 11g Certified Implementation Exam Essentials Exam Study Guide (PDF)
Oracle University Training
Oracle Data Integrator 11g: Integration and Administration
Oracle Data Integrator 11g: Advanced Integration and Development
Oracle Enterprise Data Quality: Profile, Audit and Operate
Oracle Enterprise Data Quality: Match and Parse


Additional Information & Resources
Exam Retake Policy
Specialization Catalog (PDF) for all launched and planned Specializations
Product Mapping to Specialization (XLS)


Exam Topics

Introduction to Oracle Data Integrator (ODI)

  • Benefits of ODI (including ODI architecture - Extract Load Transform)
  • ODI components

ODI Architecture Overview

  • ODI Architecture
  • Installation and Configuration
  • Fusion Middleware Components

ODI Models and Datastores

  • Creating ODI datastores
  • Creating and organizing ODI Models
  • Reverse engineering metadata
  • ODI constraints
  • Configuring auditing
  • Configuring data validation

ODI Project Development

  • Creating a project
  • The ODI interface
  • Concepts of mapping, joins, filters and implementing business rules
  • Creating and executing a basic ODI Interface
  • Creating Lookups
  • ODI interfaces with multiple-source datastores
  • Creating joins and lookups, and filter data
  • Configuring flow in the ODI Interface, specifying the ODI Interface staging area and execution location
  • Developing and modifying knowledge modules 
  • Run time
  • Monitoring execution of interfaces
  • Troubleshooting interface run-time errors and preventing errors when designing interfaces
  • Configure business rules, variables, set-based operators, using data sets and sequences
  • Partitioning, temporary indexes, and temporary interfaces
  • User functions and substitution methods

Managing ODI Execution

  • Using ODI packages to create a complete workflow
  • Using variables in packages
  • Package steps
  • Executing and monitoring packages
  • Complex workflows with branches and loops
  • Generating and regenerating ODI scenarios
  • Load plan editor to define a load plan
  • Designing a sequence of hierarchical steps for a load plan
  • Creating Packages and Load Plans
  • Managing exceptions with Load Plans
  • Configuring Load Plans to restart child sessions

Integrating Oracle GoldenGate with ODI

  • Change Data Capture (CDC) and types of CDC implementations possible with ODI
  • Deploy Oracle GoldenGate CDC with ODI
  • Journalizing
  • Interpreting and troubleshooting CDC

Doing more with ODI

  • The ODI Software Development Kit (SDK)
  • ODI Web-Based Components
  • The role of ODI in Big Data
  • The role of ODI in Business Intelligence integration

Oracle Enterprise Data Quality (EDQ) Profiling

  • ODI and EDQ architecture components
  • Configuring EDQ to work with Data Stores, Snapshots, staged Data and Exports
  • Basic statistics from data
  • Track changing data from data stores
  • Profiling results and Publish features

Oracle Enterprise Data Quality Batch Processing

  • The parsing process and referencing review results
  • Matching process, identifying duplicated records, balance performance  and duplicate detection accuracy
  • Address Verification
  • Invoke jobs including all processes from ODI


Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.

View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.



 E-mail this page  Printer View