Module 1: PowerExchange Overview

• PowerExchange Functionality
• PowerExchange Architecture
• PowerExchange components
• Features and benefits
• DBMOVER configuration file

Module 2: PowerExchange Navigator

• Navigator Objects
• Navigator functions
• Data Maps
• Copybooks
• Personal Metadata
• Managing Navigator Objects
• Lab: Creating a Data Map from an EBCDIC file

Module 3: Data Maps

• Creating a Data Map
• Defining the Records in a File
• Field Level Processing
• Adding Expression Fields
• Table Definitions
• Array processing
• Lab: Manual Data Map Creation
• Lab: Importing a Multi-Record File with a COBOL Copybook Array Processing
• Lab: Array Processing

Module 4: SQL Syntax and Personal Metadata

• Using SQL WHERE Clause for Non-Relational Database
• Using DTLDESCRIBE Function to Retrieve
• Personal Metadata
• Creating Personal Metadata
• Testing Personal Metadata
  
• Lab: Filtering Records and Array Handling
• Lab: Adding Personal Metadata

Module 5: Processing Complex Flat Files

• File and Field Data Formats
• Variable Length Binary Data
  
• Lab: Decoding a Complex Flat File

Module 6: VSAM Data Maps

• VSAM overview
  
• VSAM Datasets
• Access Methods
• Create Data Maps
• Perform row tests
• Lab: Creating a data map from a VSAM file
• Lab: Creating a data map from a Multi layout file

Module 7: PowerExchange- PowerCenter Integration

• Using PowerExchange Client for PowerCenter (PWXPC)
  
• PWXPC Advantages
• PWXPC Sources and Targets
• Lab: Integrating with PowerCenter using PowerExchange Client for PowerCenter

Module 8: PowerExchange Oracle CDC Overview

• PowerExchange Oracle RT CDC Architecture
  
• Characteristics of applications to extract changes
• Pre-requisites for using PWX Oracle CDC
• Register an Oracle Source for CDC using PWX
• Lab: Creating a Registration group

Module 9: Integrating PowerExchange Oracle CDC with PowerCenter

• Creating PowerCenter mappings and workflows using PowerExchange Client for PowerCenter (PWXPC) to connect to PowerExchange
  
• Session restart/recovery features with PWXPC
• Remote logging of data
• PowerExchange CDC Publisher
• Lab: Materializing the Target with PowerExchange Mapping and Workflow Integration
• Lab: PowerExchange CDC Mapping and Workflow Integration
• Lab: Oracle Remote logging of data
• Lab: PowerExchange CDC Mapping and Workflow Integration (Remote)
• Lab: PowerExchange CDC Publisher

Module 10: PowerExchange Field Sensitive Capture

• Field Sensitive Change Capture concepts
  
• Differences between CI (Change Indicator) and BI (Before Image)
• Filtering unwanted change records from an extraction
• Lab: Field Sensitive Change Capture

Module 11: PowerExchange Oracle CDC Overview 

• PowerExchange SQL Server CDC Architecture
• Pre-requisites for using PWX SQL Server CDC
• Configuring Consumer API (CAPI) parameters
• Enable distribution through SQL Server Management console
• Register an SQL Server source for CDC using PWX
• Manage schema changes
• Lab: Create a Registration group and perform CDC

Module 12: PowerExchange MySQL CDC Overview

• MySQL Change Data Capture
  
• Configure MySQL for CDC
• Configure PowerExchange for MySQL CDC
• Create MySQL Registration Group
• Perform row test
• Lab: Setting up MySQL
• Lab: Create a registration group and perform CDC

Module 13: PowerExchange for DB2 i5/OS, AS/400, & z/OS CDC Overview

• i5/OS Change Data Capture
  
• i5/OS PowerExchange CDC Architecture
• Extraction maps
• Extraction process
• DB2 for i5/OS Change Data Capture
• PowerExchange for DB2 Change Data Capture
• Task flow for extracting Change Data
• Demo: Setting up of AS400 DB2 for Change Data Capture
• Demo: Creating Registration Group and Perform DB2 AS/400 CDC
• Demo: Creating Registration and Performing CDC for DB2 i series/zOS

Module 14: PowerExchange Utilities

• Data Map Utility (DTLURDMO)
  
• Remote Program Utility (DTLREXE)
• Reporting Utilities
• Execution Management and Monitoring Utilities

Module 15: Monitoring, Troubleshooting, and Recovery

• Monitoring of CDC processes
  
• Heartbeat tables
• Long running transactions
• PowerExchange Services failover
• Performance enhancement opportunities in the PWX Oracle CDC environment
• Best Practices for using PWX Oracle CDC
• Troubleshooting some common problems