Informatica PowerCenter 10 Developer Level 1

Periood: 4.0 päeva

Kirjeldus

Goal:

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.

After successfully completing this course, students should be able to:

  • 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

General information:

The course is taught in local language, the course material is written in English. Course includes plenty of hands-on exercises.
Course price includes course material and catering (coffees, lunch) daily.

The course will be held Affecto Academy training facility at Atomitie 2 (Bolero Business Park), 00370 Helsinki. The course day begins at 9am and ends at 4pm. This course can also be arranged onsite at customer location.

Affecto reserves the right to make changes to courses and schedules. Affecto may cancel a course if there are less than six (6) participants. Affecto is not responsible for any expenses related to course cancellation.



Soovite lisada enda koolituse või sündmuse Oppia.ee keskkonda?

Võta ühendust!