Informatica PowerCenter 10 Developer Level 1


The course will introduce attendees to working with the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools, performing tasks such as creating transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data. They will develop cleansing, formatting, sorting and aggregating procedures. They can learn how to use routers, update strategies, parameters /variables and overrides. This course will cover many different types of lookups, such as cached, persistent, dynamic and multiple row returns. Workflow tasks will be created to define a set of instructions for executing the ETL.

After successfully completing this course, students should be able to:
  • Use Informatica Support to resolve questions and problems with PowerCenter 10.x
  • Use PowerCenter 10.x Designer to build mappings that extract data from a source to a target, transforming it as necessary
  • Use PowerCenter transformations to cleanse, format, join, aggregate and route data to the appropriate targets.
  • Perform error handling/trapping using PowerCenter mappings
  • Use PowerCenter 10.x Workflow Manager to build and run a workflow which executes a sessions associated with a mapping
  • Design and build simple mappings and workflows based on essential business needs
  • Perform basic troubleshooting using PowerCenter logs and debugger

Target audience:
Data Integration developers with little or no experience of PowerCenter.

The PowerCenter Developer Training is a level 1 course that introduces users to PowerCenter 10.x through hands-on exercises.

The course content includes the following topics:
  1. An Overview of Informatica PowerCenter
  2. ETL Fundamentals
    • Create flat file and relational Sources using the Source Analyzer
    • Create flat file and relational Targets using the Target Developer
    • Mappings using the Mapping Designer
    • Workflows using the Workflow Designer
    • Monitor the workflow using the Workflow Monitor
    • Preview Target Data using the PowerCenter Designer
  3. Troubleshooting
    • Understand PowerCenter Log files
    • Use PC log files
  4. PowerCenter Transformations, Tasks and Reusability
    • Define list of PC Designer Transformations and Workflow Tasks
    • Clarify Active vs. Passive Transformations
    • Use the Expression Transformation and Editor in a mapping
    • Use Reusable Designer Transformations
  5. Features & Techniques
    • Outline use of Arrange All and Arrange All Iconic
    • Show ‘Autolink’ feature
    • Show ‘Select Link Path’ feature
    • Define Propagation of Port Properties
  6. Joins and Link Conditions
    • Define Joins
    • Clarify Heterogeneous vs. Homogeneous Joins
    • Use a Joiner Transformation to join relational and flat file sources
    • Use the Source Qualify to join two relational sources
    • Make use of Link Conditions to execute one session when the first finishes successfully.
  7. Using the Debugger
    • Outline Debugger Interface
    • Show creation of a break point
    • Show ‘Evaluate the Expression’ functionality
    • Re-Execute mapping with different values
  8. Sequence Generators, Lookups and Caching
    • Define the Sequence Generator
    • Define the Lookup Transformation
    • Understand the different types of Lookups
    • Clarify Lookup Caching
    • Use a Flat File Lookup to add data to a relational target.
    • Create a Multiple Row Return Lookup, use Aggregators and Expressions
    • Build a Dates Lookup Cache
    • Utilize Event Wait, Event Timer and Email Tasks
    • Use a decision task
  9. Update Strategies, Routers and Overrides
    • Build a mapping that uses Update Strategies and Routers
  10. Sorter, Aggregator, Unconnected Lookups, Mapping Parameter/Variables and Mapplets/Worklets
    • Define Sorter Transformation
    • Detail Aggregator Transformation and Aggregate Functions
    • Explain Unconnected Lookups and how they are called.
    • Describe Mapping Parameters/Variables and initialization priority
    • Outline Mappets and Worklets
    • Use these Transformations to create a mapping
    • Parameter File Instruction.

General information:


The course is taught in local language, the course material is written in English. Course includes plenty of hands-on exercises.

Course price includes course material and catering (coffees, lunch) daily.

Affecto reserves the right to make changes to courses and schedules. Affecto may cancel a course if there are less than six (6) participants. Affecto is not responsible for any expenses related to course cancellation.

This course can also be arranged onsite at customer location.

The course will be held Affecto Academy training facility at Atomitie 2, 00370 Helsinki. The course day begins at 9am and end at 4pm.

VAT will be added to the prices.

For more information, please contact Academy Finland

The course will be held Affecto Academy training facility at Stortorvet 10 (GlasMagasinet), Oslo. The course day begins at 9am and end at 4pm.

For more information, please contact Academy Norway

The course will be held at either Affecto Academys training facility at Holländargatan 17B, 111 60 Stockholm or at an external training facility in Stockholm depending on the number of participants. The course day begins at 9am and end at 4pm.

VAT will be added to the prices.

For more information, please contact Academy Sweden

Duration: 4 day
Price: 2800.00 €

Registration closed

Cancellation and payment terms
Request offer
Good to know