---

This four-day, instructor-led course provides the basic skills and knowledge developers new to Informatica PowerCenter require to implement data integration projects, exposing core features of PowerCenter through lecture and hands-on exercises. In addition to gaining tremendous insight into the data integration platform, you will be exposed to Informatica Velocity Best Practices, troubleshooting techniques, and the use of technical support options. The course concludes with workshops in which you will design and implement a data integration project based on business requirements and a discussion of new features in PowerCenter 9.

Certification: PowerCenter Developer Certification

Highlights

• Use PowerCenter 8.x/9.0 Designer to build mappings that move data from sources to targets
• Use PowerCenter 8.x/9.0 Workflow Manager to build and run a workflow that runs a session based on a mapping
• Design mappings and workflows based on business needs
• Perform basic troubleshooting of PowerCenter mappings and transformations
• Use Informatica Support options to resolve questions and problems about Informatica PowerCenter 8.x/9.0

Course Outline

1. Power Center: Terminology and Architecture

• Explain the purpose of PowerCenter
• Define terms used in PowerCenter
• Name the major components of PowerCenter

2. Mapping Fundamentals

• Create source and target definitions from flat files and relational tables
• Create a mapping using existing source and target definitions
• Use links to connect ports

3. Workflow Fundamentals

• Create a basic workflow and link its tasks
• Run a workflow, monitor its execution, and verify the results

4. Expression and Filter Transformations

• Use expression xformations to perform calculations on a row-by-row basis
• Use filter xformations to drop rows based on user-defined conditions

5. Joining and Merging Data

• Use Source Qualifier xformation to implement homogeneous joins
• Use Join xformation to implement heterogeneous joins
• Use Union xformation to merge records into a single record set

6. Lookup Transformation

• Use lookup xformations to bring in additional data related to a row

7. Aggregator and Sorter Transformations

• Order a set of records based on one or more fields using the Sorter xformation
• Calculate values based on data in a set of records using the Aggregator xformation

8. Using the debugger

• Use the Debug wizard and toolbar to debug a mapping

9. Updating Target Tables

• Use a router xformation to divide a single set of records into multiple sets of records
• Use an update strategy xformation to determine how the target should handle records (insert/update/delete)

10. Mapping Techniques

• Set and use variables and parameters

11. Create and use reusable transformations

• Use an unconnected lookup to provide values on an as-needed basis

12. Mapplets

• Create mapplets and incorporate them into mappings

13. Controlling Workflows

• Set and use workflow variables
• Use link conditions and decision tasks to control the execution of a workflow
• Use other workflow tasks
• Explain the purpose of the pmcmd utility
• Correctly use bulk and normal loading
• Schedule workflows to run automatically

14. Mapping Design Workshop

• Follow best practices for mapping design
• Create a mapping based on defined business needs

15. Workflow Design Workshop

• Follow best practices for workflow design
• Create a workflow based on defined business needs

16. PowerCenter 9 New Features

• Describe the new features in PowerCenter 9

Space is limited. Register today to save your space!