PowerCenter: Performance Tuning and Optimization Training

ExistBI is an Informatica Partner

Course Description

ExistBI is an Authorized Informatica Training Partner. Our trainers are certified, enthusiastic and extremely experienced. We deliver classic or fit for purpose PowerCenter performance tuning in Informatica training in your office or via instructor-led virtual classroom to meet the needs of your organization.

This two-day course teaches students on how to optimize the performance of Informatica PowerCenter through lecture and hands-on exercises. The course is designed for advanced PowerCenter developers.

The course will introduce attendees to the various techniques and tools to perform tasks such as isolating and optimizing bottlenecks at various levels (source, transformation, target, session and system), server sizing. This course will also cover partitions and grid in more detail.

Course Outcomes

At the end of the course, learners will be able to:

  • Understand the Informatica PowerCenter arcDescribe the different types of potential bottlenecks that may affect PowerCenter’s performance
  • Describe how to isolate and optimize source, target, and engine bottlenecks
  • Apply best practices to PowerCenter mappings
  • Describe how to calculate memory used by a session and optimize session- level memory and transformation cache
  • Describe different partition types and guidelines for usage
  • Perform system optimization and server sizing
  • Understand various concepts on integration service on grid

Course Summary

Next Public Course Dates

UK & Europe:

  • 26 - 27 September 2023
  • 10 - 11 October 2023
  • 24 - 25 October 2023

US & Canada:

  • 3 - 4 October 2023
  • 17 - 18 October 2023
  • 7 - 8 November 2023
Prerequisites
  • At least six months experience in PowerCenter as a developer
  • Basic Tuning Concepts
Duration
  • 2 Days
  • 70% theoretical, 30% practical
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite
Audience
  • Experienced Informatica PowerCenter developers

Course Modules

Performance Tuning Basics

  • Describe performance tuning methodology
  • Define Benchmarking
  • Thread Statistics and performance counters
  • Describe bottlenecks at various levels
  • Define optimization and scalability

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

Book This Course

Other Training Areas of Interest

Get Notified of Upcoming Classes

Want to know when the next class will be offered? Sign up for notifications!

      To discuss your project requirements, send us a message

        For a free assessment, quick quote or training information, send us a message

          To book this course, please fill in your details and submit the form.

            To book this course, please fill in your details and submit the form.

              To discuss your training requirements or book a class, drop us a line