Database Reference
In-Depth Information
Summary
In this chapter, we talked about the various techniques using which you can enhance per-
formance. To enhance performance, we talked about source, target, and transformation bot-
tlenecks. Even after optimizing your source, target, and mapping, your performance was
not up to date, so we took a look at your session and system bottlenecks. We also saw vari-
ous ways of optimizing the components of the PowerCenter tool. Later in the chapter, we
talked about partitioning and pushdown optimization, using which also you can enhance
performance.
With this, we are done with learning all the concepts of the Informatica PowerCenter tool.
In this topic, you learned concepts that are useful for people with beginner and intermediate
level experience in the Informatica tool. We also touched upon a lot of advanced level con-
cepts in this topic. With some more practice and theory exposure, you will be able to clear
the first level in the Informatica PowerCenter certification.
