Exist Management LLC (ExistBI) are a Certified and Approved Informatica training partner in the United States, Canada, United Kingdom and Europe with the permission to deliver onsite or instructor-led online data integration training anywhere around the globe.

We deliver fit for purpose and the official four-day live instructor-led Informatica PowerCenter Level 1 Developer training that introduces delegates to 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 software is used by Developers to create, execute, monitor and schedule ETL processes.

Objectives

After successfully completing this Informatica PowerCenter training 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

Agenda

  • 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

Previous PowerCenter 9.x version agenda

Print Friendly, PDF & Email