1. Home
  2. Oracle
  3. 1Z0-448 Exam Syllabus

Oracle 1Z0-448 Exam Syllabus

Start Free 1Z0-448 Exam Practice After Reviewing the Topics

Before starting your 1Z0-448 exam preparation, it is recommended to review the complete Oracle Data Integrator 12c Essentials exam syllabus and carefully go through the exam objectives listed below. Once you understand the exam structure and objectives, you should practice using our free 1Z0-448 questions. We also provide premium 1Z0-448 practice test, fully updated according to the latest exam objectives, to help you accurately assess your preparedness for the actual exam.

Oracle 1Z0-448 Exam Objectives

Section Objectives
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
  •     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
Official Information https://education.oracle.com/oracle-data-integrator-12c-essentials/pexam_1Z0-448