Oracle 1Z0-482

Free Questions in OTE format

About Oracle 1Z0-482 dump

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.

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