Course Description | Outline | IT Home

Overview

This four-day, instructor-led course complements and extends “PowerCenter 8 Level I Developer” with advanced topics and extended labs. The course is intended for developers with more than Three months of PowerCenter 8 experience. Topics covered include: Advanced Mapping Techniques; Advanced Workflow Techniques; Transaction Control; Workflow Recovery; Error Handling; Performance Tuning; Stored Procedures and Custom Transformations; Repository Reporting; Memory Allocation; and Pipeline Partitioning.

Course Objectives:

• Describe the PowerCenter 8 architecture
• Given a mapping specification, build a corresponding mapping, using the techniques including: variables and parameter files; dynamic caching; data-driven and incremental aggregation; denormalization; user-defined and custom functions
• Control workflow behavior with restart junctions, control tables, workflow variables, and dynamic scheduling
• Configure workflows for recovery
• Use transaction control to manage writing to targets
• Configure PowerCenter’s handling of data errors
• Manage objects in one or more repositories
• Optimize PowerCenter’s memory usage
• Using a standardized methodology, optimize the performance of PowerCenter in your environment
• Use partitions and stages to improve performance

Prerequisites

Students should have completed our Informatica PowerCenter 8.x Level I course, or have equivalent experience.

Schedule

Contact Information

E-mail info@umbctrainingcenters.com or call (443) 692-6599:

• if you have any questions about this course,
• to be notified when this course and any closely related courses are scheduled for open enrollment,
• to request a quote for group training at your location or ours.