Course Description
Gain the skills necessary to use PowerExchange Client to create Data Maps, use SQL Syntax, process VSAM, DB2, SQL Server data, and integrate PowerExchange and PowerCenter. Learn to deliver data on demand in batch and Change Data Capture (CDC) modes using PowerExchange with Oracle, SQL Server, and AS400 DB2. Applicable for software version 10.2
Course Objectives
At the end of the course, learners will be able to:
- Discuss PowerExchange benefits and architecture
- Use the Navigator to create data maps for flat files, and VSAM.
- Create data maps for complex non-relational files
- Create personal metadata
- Create registrations for DB2
- Integrate PowerExchange with PowerCenter
- Perform Oracle change data capture (CDC) with Databases such as Oracle, SQL Server, and DB2
Course Summary
Next Public Course Dates | |
| Prerequisites | |
| Duration |
|
| Available Formats |
|
Course Modules
PowerExchange Overview
- PowerExchange Functionality
- PowerExchange Architecture
- PowerExchange components
- Features and benefits
- DBMOVER configuration file
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
Testimonials
“The content was great for an introduction to Tableau. I truly appreciate the way Michael was able to explain everything, and would recommend this class to anyone needing to get their feet wet with Tableau.”
- Shianne DeGeorge, Business Intelligence Group, Kaiser Permanente
Thoroughly enjoyed the training. The trainer was fantastic! It is rare but always an awesome experience when a trainer is also an experienced practioner with a breadth of knowledge and hands on experience… even well beyond the subject matter at hand. I had the feeling that the trainer could have answered in detail any question we might have had related to not only BDM but Hadoop and other relevant big data topics as well. Time well spent and I hope to encounter Tomi again.
- Rick Kirk, CTO, Alliant Energy / Ernst & Young
“Our Informatica Axon and Enterprise Data Catalog training classes were all excellent for our needs. The trainer really knew a lot about data governance strategy, frameworks, stewardship and actual implementation. As a senior consultant, he had implemented many projects, this really helped in Q&A. Highly recommended.”
- Susan Charles, IT Director, SoFi Bank
