INFA02: INFORMATICA PowerCenter v9.x Level 2 Developer

This 3-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 3 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.
 

- PowerCenter 9.x Level 1 Developer
- 3 Months or more experience working with PowerCenter 

1. PowerCenter Overview
Describe the Components of the PowerCenter 9 Architecture and define key terms
Describe PowerCenter's optional and built-in high availability features

2. User-Defined & Advanced Functions
Describe User Defined Function to Create Entity Types
Describe & implement advanced functions

3. Pivoting Data
Describe the use of the normalizer and aggregator transformation to normalize and de-normalize date

4. Stored Procedure & SQL Transformations
Describe the use of the Stored Procedure transformation in a mapping or mapplet
Describe the uses of the SQL Transform

5. Transaction Processing
Describe Source based & Target based transaction controls with and without high availability option
Describe the use of PowerCenter constraint-based loading in databases with referential integrity constraints

6. Transaction Control Transform
Describe the use of the transaction control transformation for data-driven transaction control
Describe control when data is committed to disk or the target database

7. Workflow & Task Recovery
Describe workflow and task recovery with and without the high availability option
Recover tasks and workflows that stop, abort or terminate
Explain and use PowerCenter's built-in recovery capabilities
Explain the user-designed recovery techniques
Design error handling strategies appropriate for the intended purpose of a workflow

8. Command Line Utilities
Use pmcmd to start, restart  and recover workflows
Use pmrep for object export, mass validation, object import, back-up and EBF migration of a unit or work

9. Performance Tuning: Methodology
Describe Performance counters
Describe busy percentages & how they help in bottleneck isolation
Describe thread utilization to identify a target bottleneck
Describe thread utilization to identify a transformation bottleneck
Describe thread utilization to identify a source bottleneck
Describe types of target bottlenecks: database, network, disk & PowerCenter
Describe 3 alternatives to the update-else-insert scenario
Describe how transaction control impacts performance
Describe Types of source bottlenecks: database, network, disk & PowerCenter
Describe tune the line sequential buffer
Describe external loader effects on targe bottlenecks

10.  Performance Tuning: Mapping Design
Explain types of data type conversion: port-to-port, expression-to-port and explicit
Identify which transformations increase or decrease the number of rows
Explain the performance implications of the stored procedure vs. the SQL transformation

11. Performance Tuning: Caching & Memory Optimization
Describe  data caching & RAM memory optimization techniques to improve session performance
Describe DTM buffer pool optimization

12. Performance Tuning: Partitions
Describe how pipelines & partitions affect performance
Describe 3 options for merging partitions: sequential, concurrent & file list
Describe how partitioning affects the DTM buffer pool