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 | |
| Prerequisites |
|
| Duration |
|
| Available Formats |
|
| Audience |
|
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
Testimonials
“The trainer was INCREDIBLE. He was extremely passionate, made sure to consistently ask if anybody needed help, logged on early to answer any questions, and was an overall great human being.”
- Salvatore, Hilton Grand Vacations
Thoroughly enjoyed the training. The trainer was fantastic! It is rare but always an awesome experience when a trainer is also an experienced practioner with a breadth of knowledge and hands on experience… even well beyond the subject matter at hand. I had the feeling that the trainer could have answered in detail any question we might have had related to not only BDM but Hadoop and other relevant big data topics as well. Time well spent and I hope to encounter Tomi again.
- Rick Kirk, CTO, Alliant Energy / Ernst & Young
“The Tableau Visual Analytics session with Michael was awesome, he is a really good instructor”
- Graciela Kahn, Director, Business Intelligence, NeighborWorks America
