Exam Title: Oracle Data Integrator 12c Essentials
Exam Number: 1Z0-448
Exam Price: $245.00 More on exam pricing
Format: Multiple Choice
Duration: 120 minutes
Number of Questions: 79
Passing Score: 71%
Validated Against: This exam is validated against Oracle Data Integrator 12c.
Take Recommended Training Courses
Complete one of the courses below to prepare for your exam (optional):
Oracle Data Integrator 12c: Integration and Administration
Oracle Data Integrator 12c: Advanced Integration and Development
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Oracle Data Integrator 12c Certified Implementation Specialist
Introduction to Oracle Data Integrator (ODI)
Describe the benefits of ODI and its typical use cases
Describe the ODI components and their uses
ODI Models and Datastores
Create ODI datastores
Create and organize ODI models
Use reverse engineering metadata
Explain ODI constraints
Configure auditing
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
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
Architecture Overview
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
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
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
