Informatica PowerCenter Training – Developer, Level 1

ExistBI is an Informatica Partner

Course Description

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

We deliver fit for purpose and the official four-day live instructor-led Informatica PowerCenter training, Level 1 Developer 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:

  • 21 - 24 May 2024
  • 4 - 7 June 2024
  • 2 - 5 July 2024

US & Canada:

  • 28 - 31 May 2024
  • 11 - 14 June 2024
  • 25 - 28 June 2024

More dates

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:

    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 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