Objectifs : Après avoir suivi la formation, le stagiaire est capable de :
Describe the Informatica PowerCenter architecture
Describe user defined and advanced functions
Describe the use of Mapping Variables and Parameter Files.
Describe how to Normalize and Denormalize data using PowerCenter
Describe the Stored Procedure transformation and its two modes of use
Describe the SQL Transformation
Describe PowerCenter source-based, target-based, and user-based transaction control
Describe constraint-based loading
Describe the Transaction Control transformation for data-driven transaction control.
Describe built-in, optional, and mapping design recovery capabilities
Describe built-in and optional High Availability functions
Describe PMCMD and PMREP command-line functionality
Describe PowerCenter Performance Tuning Methodology including performance counters, thread utilization, source, target, and integration service bottlenecks, and the impact of the update-else-insert setting.
Describe the effect of mapping design on performance.
Apply these design principles by building a new mapping.
Describe the effect of caching and RAM on performance.
Describe the transformations that cache data, the DTM buffer pool, and the use of cache calculators.
Describe PowerCenter Partitioning rules, types and effect on the DTM buffer pool.