On the delivery side, PowerExchange has the ability to deliver data On Demand. PowerExchange can deliver the data in batch mode, or in Change Data Capture mode. Within CDC mode, the changes can be delivered in Real Time or at intervals. This 8-hour, instructor-led class delivered via the Informatica Virtual Academy, introduces PowerExchange for Oracle Real-Time Change Data Capture (CDC) using the PowerExchange Client for PowerCenter.


  • After successfully completing this course, students should be able to:
  • Use the PowerExchange for Oracle CDC option with PowerCenter to perform Oracle change data capture (CDC)


Module 1: Overview & Configuration

  • Describe the PowerExchange Oracle RT CDC Architecture
  • Describe the characteristics of Oracle’s Logminer Application
  • Describe the Pre-requisites for using PWX Oracle CDC
  • Register an Oracle Source for CDC using PWX

Module 2: Integrating PowerExchange with PowerCenter

  • Create PowerCenter mappings and workflows using PowerExchange Client for PowerCenter (PWXPC) to connect to PowerExchange
  • Describe session restart/recovery features with PWXPC

Module 3: PowerExchange Field Sensitive Capture

  • Describe the concept of Field Sensitive Change Capture
  • Identify the difference between CI (Change Indicator) and BI (Before Image)
  • Filter unwanted change records from your extraction

Module 4: Tips and Tricks

  • Utilize a Flexible Key Transformation to properly update changed target keys
  • Identify performance enhancement opportunities in the PWX Oracle CDC environment
  • Describe Best Practices for using PWX Oracle CDC

Module 5: Administration

  • Explain the importance of understanding Capture vs Consume
  • Describe the Administration Set Up tasks for PWX Oracle
  • CDC
  • Configure the Oracapt.sql, dbmover.cfg, and the dtlca.cfg (if necessary) for your environment
  • Discuss Performance and Configuration Consideration