Informatica PowerCenter Level 2 Developer

ExistBI is an Informatica Partner

Course Description

Our Certified Informatica trainers deliver the 4-day Informatica PowerCenter Level 2 Developer training course with materials and hands-on labs. This Informatica training is for ETL developers who have already taken PowerCenter Level 1 Developer training or have worked with PowerCenter for a number of years. The Level 2 Developer class 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 tuning workshops that include methodology, mapping design, and cache management with memory optimization.

Course Outcomes

At the end of the course, learners will be able to:

  • Understand the Informatica PowerCenter architecture
  • Determine the structure and use of PowerCenter Parameter Files
  • Implement user-defined and advanced functions.
  • Normalize and Denormalize data using PowerCenter
  • Use the Lookup transformation in Dynamic mode
  • Call a SQL stored procedure from a PowerCenter mapping
  • Create and configure a SQL transformation and its two modes of use
  • Design error handling strategies appropriate for the intended purpose of a workflow
  • Make use of the PowerCenter source-based, target-based, and user-based transaction control
  • Utilize constraint-based loading in databases with referential integrity constraints
  • Use the Transaction Control transformation for data-driven RDBMS transaction control
  • Determine the proper use of built-in and optional, mapping-design recovery capabilities
  • Build batch files that use PMCMD and PMREP command line programs
  • Apply PowerCenter Performance Tuning Methodology
  • Describe the effect of mapping design on performance and apply these design principles to a mapping
  • Calculate how much memory a session uses and tune session-level memory Apply partitions, distribute the data and optimize the CPU memory usage

Course Summary

Next Public Course Dates

UK & Europe:

  • 25 - 28 February 2025
  • 11 - 14 March 2025
  • 25 - 28 March 2025

US & Canada:

  • 18 - 21 February 2025
  • 4 - 7 March 2025
  • 18 - 21 March 2025

More dates

Prerequisites
Duration
  • 4 Days
  • 60% theoretical, 40% practical
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite
Audience
  • Data Integration developers who have taken the introductory PowerCenter Level 1 Developer course

Course Modules

PowerCenter 10 Architecture

  • Describe the components of the Informatica PowerCenter 10 architecture and define key terms
  • Describe PowerCenter’s optional and built-in high availability features

Transaction Processing

  • Describe PowerCenter source-based, target-based, and user-based transaction control with and without the high availability option
  • Describe constraint-based loading in databases with referential integrity constraints
  • Load data to a set of tables with a RDBMS Primary-Foreign key relationship

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

    To discuss your project requirements, send us a message

      For a free assessment, quick quote or training information, send us a message

        To book this course, please fill in your details and submit the form.

          To book this course, please fill in your details and submit the form.

            To discuss your training requirements or book a class, drop us a line