prevnext Informatica PowerCenter Level I Developer

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.

PowerCenter 8.x/9.0 Level I Developer Content Details

Power Center: Terminology and Architecture

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

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

Workflow Fundamentals

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

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

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

Lookup Transformation

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

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

Using the debugger

• Use the Debug wizard and toolbar to debug a mapping

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)

Mapping Techniques

• Set and use variables and parameters

Create and use reusable transformations

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

Mapplets

• Create mapplets and incorporate them into mappings

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

Mapping Design Workshop

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

Workflow Design Workshop

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