Informatica PowerCenter 8.6 Developer Level 1

Informatica PowerCenter – ETL tool for data warehouses and data-integration projects. In this course we will talk about some basic information regarding ETL architecture, IPC features and components. Practical exercises and tasks will offer participants the opportunity to practice their skills in mapping creation and workflow design, defining and analyzing the results as well as bug fixing.
  • duration 16 hours
  • Language English
  • format Training
duration
16 hours
location
Online
Language
English
Code
EAS-001
price
€ 300 *

Available sessions

To be determined



Training for 7-8 or more people?
Customize trainings for your specific needs

Description

Informatica PowerCenter – ETL tool for data warehouses and data-integration projects. In this course we will talk about some basic information regarding ETL architecture, IPC features and components. Practical exercises and tasks will offer participants the opportunity to practice their skills in mapping creation and workflow design, defining and analyzing the results as well as bug fixing.
After completing the course, a certificate is issued on the Luxoft Training form

Objectives

  • Using PowerCenter Designer v.8.6/9.5 to create mappings of data transformation from sources to targets.
  • Using PowerCenter 8/9 Workflow Manager to create and start a workflow and sessions.
  • Developing mappings and workflows based on business tasks.
  • Error searching and troubleshooting in mappings and transformations.

Target Audience

Developers (preferably with experience in integration projects).

Prerequisites

Theoretical training or participation in integration projects.

Roadmap

  • Mapping Fundamentals.
  • Workflow Fundamentals.
  • Expression and Filter Transformations.
  • Techniques demonstration.
  • Joining and Merging Data.
  • Lookup Transformation.
  • Aggregator and Sorter Transformations.
  • Updating Target Tables.
  • Using the debugger.
  • Mapping Techniques.
  • Mapplets.
  • Controlling Workflows.
  • Mapping Design Workshop.

Discover more about professional growth and skills development

contact us