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.

16 hours
English
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

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.