Course Overview

This course extends the skills and knowledge of experienced PowerCenter developers. Reviewing advanced topics with extended labs covering PowerCenter connection architecture, high availability, and session and workflow recovery. Additional transformations are introduced including the SQL transformation, transaction control with and without the Transaction control transformation. Review the extended and advanced use of the Lookup transformation. Further included is an extensive series of performance and tuning workshops that include methodology, mapping design, and cache management with memory optimisation.