Informatica PowerCenter 10.x Level II Developer

Informatica PowerCenter 10.x Level II Developer


Course Description

This 3-Day, instructor-led course compliments and extends "PowerCenter 9.x Level 1 Developer" with advanced topics and extended Labs. 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.

  • Duration: 3 days
  • Language: English
  • Format: Instructor-led
  • Location: Aexis' premises or onsite
  • Audience: Database Developers with six months or more experience with PowerCenter
  • Prerequisites: PowerCenter 9.x Level 1 Developer , 3 Months or more experience working with PowerCenter

Course Objectives

  • Describe the Informatica PowerCenter Architecture
  • Describe user defined and advanced functions
  • Describe how to Normalize and De-Normalize data using PowerCenter
  • Describe the Stored Procedure transformation and its' two modes of use
  • Describe the SQL Transformation
  • Describe PowerCenter source-based, target-based and user-based transaction control
  • Describe constraint-based loading
  • Describe the Transaction Control Transformation for data-driven transaction control
  • Describe built-in and optional High Availability functions
  • Describe PMCMD and PMREP command-line functionality
  • Describe PowerCenter Performance Tuning Methodology including performance counters, thread utilization, source, target and integration service bottlenecks, and the impact of the update-else-insert setting
  • Describe the effect of mapping design on performance
  • Apply these design principles by building a new mapping
  • Describe the effect of caching and RAM on performance
  • Describe the transformations that cache data, the DTM buffer pool, and the use of cache calculators
  • Describe PowerCenter Partitioning rules, types, and effect on the DTM buffer pool