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.
Prerequisites
Objectives
- 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)
Agenda
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