Exist Management LLC (ExistBI) are an authorized Informatica training partner. We deliver the official four-day instructor-led Informatica PowerCenter training course that introduces delegates to Informatica PowerCenter through lecture and hands-on labs. This course is designed for ETL Developers who have no or little experience using this comprehensive PowerCenter tool. The PowerCenter software is used by Developers to create, execute, monitor and schedule ETL processes.

For more experienced developer teams or if your team is switching ETL tools, we can deliver a 5-day custom Level 1 and Level 2 PowerCenter training course.

Objectives

After successfully completing this PowerCenter course, you will be able 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

Course Duration

  • Four days of instructor led PowerCenter training
  • 60% lecture, 40% hands-on

Pre-requisites

  • SQL knowledge
  • Understanding of data warehouse fundamentals

Audience

  • Data integration / ETL developers

Official Informatica Agenda

  • Informatica PowerCenter Overview
  • ETL Essentials: How to use Source Analyzer, Target Developer, Mapping Designer, Workflow Designer, Workflow Monitor and PowerCenter Designer
  • Trouble Shooting: PowerCenter Log files
  • PowerCenter Transformations & Tasks
  • Apply formatting logic with Reusability Designer
  • How to Join and Link Conditions
  • Caching & Lookups
  • Sequence Generators
  • Update Strategies, Routers and Overrides
  • How to use the Debugger
  • Sorter, Aggregator, Unconnected Lookups
  • Mapping Parameter & Variables
  • Maples & Worklets
  • Hands-On Case study: Mapping Design & Velocity Methodology Best Practices
  • Hands-On Case study: Workflow Design & Velocity Methodology Best Practices
Print Friendly, PDF & Email