In this chapter, we talked about various techniques using which you can enhance the performance. We talked about source, target, and transformation bottlenecks. Even after optimizing your source, target, and mapping, your performance is not up to date, then take a look at your session and system bottlenecks. We also slooked at various ways of optimizing the components of the PowerCenter tool. Later, we discussed partitioning and pushdown optimization, using which you can enhance the performance.
With this, we have completed all the concepts of the Informatica PowerCenter tool. In this book, you have learned concepts that are useful for beginner- and intermediate-level experience in the Informatica tool. We have also touched on a lot of advance-level concepts in this book. With some more practice and theory exposure, you will be able to clear the first level in the Informatica Power Center certification.