Informatica PowerCenter Training For Beginners – Level 1 Developer

ExistBI is an Informatica Partner

Course Description

Exist Management LLC (ExistBI) is 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.

Course Outcomes

At the end of the course, learners will be able to:

  • Use the PowerCenter Designer interface to design data transformations.
  • Manage a variety of source and target definitions.
  • Filter, join, aggregate, categorize, merge, and apply expression logic to data without writing SQL.
  • Monitor and repair PowerCenter Sessions and Workflows.
  • Troubleshoot mapping problems with the debugger.
  • Leverage object reusability (build-once, use everywhere)
  • Benefit from specific Agile Data Integration best practice techniques.

Course Summary

Next Public Course Dates

UK & Europe:

  • 2 - 5 October 2023
  • 16 - 19 October 2023
  • 6 - 9 November 2023

US & Canada:

  • 25 - 28 September 2023
  • 23 - 26 October 2023
  • 13 - 16 November 2023
Prerequisites
  • None
Duration
  • 4 Days
  • 60% theoretical, 40% practical
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite
Audience
  • Data Integration developers with little or no experience of PowerCenter
  • Database Developers and developer Managers new to Informatica PowerCenter

Course Modules

Introduction to PowerCenter

  • How PowerCenter performs data integration
  • Advantages of code-free and SQL-free development
  • Informatica architecture
  • PowerCenter components and applications
  • PowerCenter object types
  • Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows and Workflow Monitor

Command Tasks

  • Running command line statements within a Workflow
  • Lookup caching properties
  • Persistent lookup caches
  • Aliasing a lookup port

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

Other Training Areas of Interest

Get Notified of Upcoming Classes

Want to know when the next class will be offered? Sign up for notifications!

    To discuss your project requirements, send us a message

    For a free assessment, quick quote or training information, send us a message

    To book this course, please fill in your details and submit the form.

    To discuss your training requirements or book a class, drop us a line