1Z0-448: Oracle Data Integrator 12c Essentials


Exam Number: 1Z0-448

Exam Title: Oracle Data Integrator 12c Essentials


Associated Certification Paths



Oracle 1Z0-448 Certification Details:


Exam Name Oracle Data Integrator 12c Essentials
Exam Code 1Z0-448
Exam Product Version Data Integrator (ODI)
Exam Price USD $245
Duration 120 minutes
Number of Questions 79
Passing Score 71% 
Validated Against This exam is validated against Oracle Data Integrator 12c.
Format Multiple Choice
Recommended Practice 1Z0-448 Online Practice Exam

Oracle 1Z0-448 Certification Topics:


Introduction to Oracle Data Integrator (ODI)
  • Describe the benefits of ODI and its typical use cases
  • Describe the ODI components and their uses
Architecture Overview
  • Describe ODI Architecture
  • Install and configure the physical and logical architecture
  • Explain Fusion Middleware Components including Upgrade Assistant, Repository Creation Utility, and Java Enterprise Edition (JEE) Components
  • Explain the differences between the different ODI Agent types
ODI Models and Datastores
  • Create ODI datastores
  • Create and organize ODI models 
  • Use reverse engineering metadata
  • Explain ODI constraints
  • Configure auditing
Project Development
  • Create a project within ODI
  • Explain an ODI mapping
  • Describe the concepts of expressions, components as well as the concepts of staging area and execution location
  • Use mapping components and expressions
  • Configure the physical design of a mapping (knowledge modules, staging area and execution location)
  • Create and execute an ODI mapping
  • Modify and develop knowledge modules
  • Describe run time
  • Monitor the execution of interfaces
  • Troubleshoot and prevent run-time errors in mappings
  • Describe the use of reusable Mappings
Managing Execution
  • Use ODI packages to create a complete workflow
  • Use variables in packages (refresh, startup parameters).
  • Create package steps of different types
  • Execute and monitor a package
  • Use complex workflows in ODI packages, including branches and loops
  • Design a sequence of hierarchical steps in a load plan
  • Compare packages and load plans
  • Manage exceptions with load plans
  • Configure load plans to restart child sessions
Integrating OGG with ODI
  • Describe the purpose of Changed Data Capture (CDC) with ODI
  • Explain ODI CDC with GoldenGate - this is learner level…please update
  • Perform ODI journalizing 
  • Interpret and troubleshoot the results of CDC
Doing more with ODI
  • Configure the ODI Software Development Kit (SDK)
  • Install the Web-based components of ODI
  • Explain how ODI is used with Big Data technologies

Oracle 1Z0-448 - Oracle Data Integrator 12c Essentials Exam Preparation: