In Informatica PowerCenter Developer training course delegates will learn to work through the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools while performing tasks such as creating source and target definitions, transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data.
By attending Informatica PowerCenter Developer - Level 1 workshop, delegates will learn to:
- Utilize PowerCenter Designer to build mappings that extract data from a source to a target, transforming it as necessary
- Deploy PowerCenter transformations to cleanse, format, join, aggregate and route data to appropriate targets
- Perform error handling/trapping using PowerCenter mappings
- Use PowerCenter Workflow Manager to build and run workflows which execute sessions associated with a mapping and to control data transformation processes.
- Design and build simple mappings and workflows based on essential business needs
- Complete basic troubleshooting using PowerCenter logs and debugger
By attending Informatica PowerCenter Developer - Level 2 workshop, delegates will learn 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
For Informatica PowerCenter Developer - Level 2 : Attending one of the below trainings or having equivalent knowledge / experience.
- Informatica PowerCenter: Developer, Level 1
- Informatica PowerCenter: Data Integration for Developers
For both the levels :