Course Overview
PowerCenter 10 is the latest release of Informatica's data management platform. The platform enables enterprises using large volumes of data to modernize and simplify their data architecture. PowerCenter 10 gives enterprises the data agility and flexibility for use in on-prem, on cloud or hybrid environments. It also performs seamlessly across Informatica's 3 major components consisting of Informatica Data Integration Hub and Informatica Data Quality.

What is the estimated course duration?
PowerCenter 10: Developer, Level 2 is a self-paced, on-demand course. Applicants can get enrolled into the course as and when desired without any requirement to attend regular class hours, specific timings or even location.

Duration
4 Days / 45 Hours

Course Cost
$500 to $600

Training Format
1) Instructor-Led Online (Virtual) Training
2) Public Classroom Training
3) Self-paced video Training
4) Workshop

What are the objectives for this course?
The objective of this course is to train applicants to become experts at using PowerCenter 10: Developer, Level 2. 

On completion of the course, they will become adept at
1) Determining the structure and using PowerCenter Parameter Files
2) Implement user-defined and advanced PowerCenter functions
3) Use lookup transformation in Dynamic mode
4) Utilize constraint-based loading in databases with referential integrity constraints
5) Calculate session-wise memory usage and tune session-level memory
6) Performing several other ancillary and associated PowerCenter 10 functions.

Who are the target audience for PowerCenter 10: Developer, Level 2 course?
This course is intended for Developers who want to upgrade their skills in PowerCenter 10: Developer, Level 2.

What are the prerequisites for PowerCenter 10: Developer, Level 2?
PowerCenter 10: Developer, Level 1 is the desired prerequisite to enroll for this course. Understanding of RDBMS concepts and Knowledge of SQL.

Course Content

Module 1: PowerCenter ArchitectureInformatica PowerCenter 10 architecture and key terms
PowerCenters optional and built-in high availability features

Module 2: Parameters
1) Is ExprVar property in a mapping
2) Structure of a parameter file
3) Parameter files in mappings and sessions
4) Parameter files used to build mapping expression logic
5) Date/time mapping variable, in a parameter file for incremental loading

Module 3: Advanced Functions and Debugging
1) Advanced functions
2) User-Defined functions
3) Standard name formatting function and implementing UDF in mappings
4) AES_Encrypt and Encode functions
5) Debug the mapping

Module 4: Data Normalization and Denormalization
1) Normalizer transformation
2) Aggregators
3) Normalization of data into a relational table
4) Denormalization of data into a Fact table

Module 5: Lookups
1) Dynamic Lookup Cache
2) Dynamic Lookup to load data into a dimension table
3) Dynamic Lookup used in tandem with an Update Strategy transformation to keep historic data in a dimension table

Module 6: Stored Procedure and SQL Transformations
1) SQL stored procedures
2) SQL transformations in script mode
3) SQL transformations in query mode
4) SQL transformation used to create tables
5) Proper query formatting for SQL transformation
6) Database errors

Module 7: Troubleshooting Methodology and Error Handling
1) Error handling strategies
2) Data errors
3) Update Strategies

Module 8: Transaction Processing
1) Source-based, target-based, and user-based transaction control with and without the High Availability option
2) Constraint-based loading in databases with referential integrity constraints
3) Table Loading and the RDBMS Primary-Foreign key relationship

Module 9: Transaction Control Transformation
1) Transaction control transformation for data-driven transaction control
2) Data Control
3) Transformation variables

Module 10: Recovery
1) Workflow and task recovery with and without the high availability option
2) Recover tasks and workflows

Module 11: Command-Line Programs
1) PMCMD, PMREP, and INFACMD command line functionality
2) Batch files that use PMCMD and PMREP
3) Command line utilities

Module 12: Performance Tuning Methodology
1) Source, target and engine bottlenecks
2) Performance counters
3) Tuning different types of bottlenecks
4) Benchmark tests
5) Target bottleneck tests
6) Results evaluation

Module 13: Performance Tuning Mapping Design
1) Best practices in mappings
2) Session properties
3) Inspect and edit mappings
4) Inspect and edit transformations

Module 14: Memory Optimization
1) Session-level memory
2) Transformation caches
3) PowerCenter Performance Counters

Module 15: Performance Tuning: Pipeline Partitioning
1) Partition points
2) Data Partitions
3) Memory optimization
4) Learn All About PowerCenter 10: Developer, Level 2