Informatica PowerExchange Training: Oracle CDC

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

PowerCenter training: Level 1 Developer

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

Class Schedule:

Our 2019/20 live instructor-led 1-day Informatica PowerExchange training dates are as follows:

2019/20
November
December
January
February
20th
March
April
29th

Book This Class

Depending on the Informatica PowerExchange training needs of your organization, we can offer classes in your office or via a virtual training environment. Just e-mail training@existbi.com and tell us which Informatica training classes you’re interested in, the proposed class size, whether you would like it to be held onsite or virtually and we’ll immediately get back to you with the relevant information.