This course is applicable to software version 10.1. Enhance your developer skills with advanced techniques and functions for PowerCenter. This course focuses on additional transformations and transaction controls, as well as, teaches performance tuning and troubleshooting for an optimized PowerCenter environment.
After successfully completing this course, students should 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
Why should you get Informatica PowerCenter certification?
Forrester claims Informatica PowerCenter to be the most preferred ETL technology which clearly proves its importance across the industries. More and more companies are inclining towards effective ETL tools to help synchronize the enterprise-wide data. Informatica is known for its effective data integration and data quality features that let enterprises deal with multiple processes simultaneously. Clearly getting Informatica PowerCenter certified will be the wisest decision if you are planning to take your career to this direction. Intellipaat offers Online Informatica training course that is aligned to the skill-set required to clear these certifications.