The course is designed for ETL Developers who are experienced with Informatica PowerCenter.
Database Developers with tree months or more experience with PowerCenter.
Has completed PowerCenter Level 1 Developer
This 4-Day, instructor-led course compliments and extends “PowerCenter 9.x Level 1 Developer” with advanced topics and extended Labs. This course is intended for developers with more than 6 months of PowerCenter 9 experience. Topics covered include: High Availability, Pipeline Look-up & Dynamic Look-up Expressions, SQL Transformation & Transaction Control Transformations. Additional topics include: Extended Use of Parameter Files, Use of Command Line Utilities and Mapping Architect for Visio. The course also includes an extensive series of Performance Tuning Workshops including: Methodology, Mapping Design & Cache Management with Memory Optimization.
Training is based on theory and explanations to funtionality in presented in plenum and hands-on exercises. The course material is in English but teaching is carried out in Danish.
1. PowerCenter Overview
2. User-Defined & Advanced Functions
3. Pivoting Data
4. Stored Procedure & SQL Transformations
5. Transaction Processing
6. Transaction Control Transform
7. Workflow & Task Recovery
8. Command Line Utilities
9. Performance Tuning: Methodology
10. Performance Tuning: Mapping Design
11. Performance Tuning: Caching & Memory Optimization
12. Performance Tuning: Partitions