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
Testimonials
Thoroughly enjoyed the training. The trainer was fantastic! It is rare but always an awesome experience when a trainer is also an experienced practioner with a breadth of knowledge and hands on experience… even well beyond the subject matter at hand. I had the feeling that the trainer could have answered in detail any question we might have had related to not only BDM but Hadoop and other relevant big data topics as well. Time well spent and I hope to encounter Tomi again.
- Rick Kirk, CTO, Alliant Energy / Ernst & Young
“ExistBI has provided multiple Microsoft Power BI training to our HR, Product and Sales teams. We’ve now engaged them to assist with complex Financial reports”
- Jena Bomboy, HR Director, The Giant Company
“ExistBI, Thank you again for the great Microsoft Power BI, PowerApps and Power Automate courses, our team was very happy”
- Kerry Urofsky, Systems Manager, Service, Avantik
