Informatica PowerCenter 8.6 Developer Level 1
Duration
16
hours
Location
Training
Language
English
Code
EAS-001
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
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.