Informatica PowerCenter 10.x Level I Developer

Informatica PowerCenter 10.x Level I Developer


Course Description

This course can be delivered through a four-day instructor led format or through our onDemand Labs Plus offering, which is comprised of 16 modules and 17 labs. The course introduces students to Informatica PowerCenter 10.x through lecture and hands-on exercises.

Informatica PowerCenter is a collection of thick client workbench tools that Developers can use to create, execute, monitor and schedule ETL processes.

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.

  • Duration: 4 days
  • Language: English
  • Format: Instructor-led
  • Location: Aexis' premises or onsite
  • Audience: The course is designed for Database Developers who are new to Informatica PowerCenter.
  • Prerequisites: Windows GUI, RDBMS concepts

Course Objectives

  • 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