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 | |
Prerequisites |
|
Duration |
|
Available Formats |
|
Audience |
|
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