Learning Informatica PowerCenter 9.x
What other items do customers buy after viewing this item?
Customers who viewed this item also viewed
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter mobile phone number.
Customers who bought this item also bought
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
Most helpful customer reviews on Amazon.com
The book is riddled with grammatical errors, weird syntax, and odd phrase and word choices.
The technical content can not be followed due to missing dependencies.
This book could seriously benefit from a complete revision.
This is a great book for learning PowerCenter development from scratch. It covers most of the same content as the official Informatica PowerCenter Level 1 Developer training, but in a book that you can read in less than one day instead of four days in the training class. It provides thorough coverage of all the functions, but it leaves out some expert guidance.
For example, it has five pages of information on the Joiner Transformation, but the book doesn’t state that the developer should always provide sorted input into the Joiner. It also doesn’t include the guidance from the official Informatica documentation that when the input is sorted, the source with fewer duplicate key values should be selected as the master source for optimal performance.
Chapter 3: Implementing SCD - Using Designer Screen Wizards seems too advanced for the intended audience of this book. New developers would be better served by skipping this chapter and reading Ralph Kimball's “The Data Warehouse ETL Toolkit” instead.
This book is for beginners who want to create their first PowerCenter mappings and workflows as well as learn about some of the other functions of the software. Chapter 9: Optimization - Performance Tuning provides some good tips, but the developer will need to learn from experience which tips are the most likely to improve the performance because this chapter is a laundry list of tips instead of an ordered list of steps. The appendix provides a good overview of Informatica administration and will help the developer understand the platform.
After reading this book, the developer should create 20 to 40 mappings and workflows and then take the official Informatica PowerCenter Level 2 Developer training to gain a deeper understanding of the software. This book will get you started, but experience and guidance is necessary to create ETL which is easily maintained and performs well.