Duration

4 days

Target audience

The course is designed for ETL Developers who are experienced with Informatica PowerCenter.

Prerequisites

Database Developers with tree months or more experience with PowerCenter.
Has completed PowerCenter Level 1 Developer

Goal

This 4-Day, instructor-led course compliments and extends “PowerCenter 9.x Level 1 Developer” with advanced topics and extended Labs. This course is intended for developers with more than 6 months of PowerCenter 9 experience. Topics covered include: High Availability, Pipeline Look-up & Dynamic Look-up Expressions, SQL Transformation & Transaction Control Transformations. Additional topics include: Extended Use of Parameter Files, Use of Command Line Utilities and Mapping Architect for Visio. The course also includes an extensive series of Performance Tuning Workshops including: Methodology, Mapping Design & Cache Management with Memory Optimization.

Content

Training is based on theory and explanations to funtionality in presented in plenum and hands-on exercises. The course material is in English but teaching is carried out in Danish.

1.  PowerCenter Overview
2.  User-Defined & Advanced Functions
3.  Pivoting Data
4.  Stored Procedure & SQL Transformations
5.  Transaction Processing
6.  Transaction Control Transform
7.  Workflow & Task Recovery
8. Command Line Utilities
9. Performance Tuning: Methodology
10.  Performance Tuning: Mapping Design
11. Performance Tuning: Caching & Memory Optimization
12. Performance Tuning: Partitions

Date and time

On demand

Location

Copenhagen

Price

Kr. 22.000