Course Overview
This Boot Camp for Developers Informatica PowerCenter 9.5.1 course teaches advanced mapping techniques and performance tuning and provides a thorough review of session partitioning features found in PowerCenter version 9.5.1. This course builds on the four-day Foundation boot camp course.
Requirements
- Some Informatica PowerCenter experience
Target audiences
- Analysts
- Developers
Curriculum
- 1 Section
- 17 Lessons
- 4 Days
Expand all sectionsCollapse all sections
- Topics17
- 1.1Course Introduction Course Objectives Introduction to informatica PowerCenter Components & Architecture
- 1.2Designer Overview Interface Tools
- 1.3Live Demo: creating and debugging a mapping Concepts Mappings Sources and Targets Transformations Objects Transformation Objects in Depth I Source Qualifier Expression Filter Aggregator Target Instance Lookup
- 1.4Working with Flat Files Importing & editing flat file sources & targets Flat file data-types
- 1.5Review Quiz Using the Debugger Debugging process and strategies Breakpoints, evaluate expressions
- 1.6Designer Tips Documenting objects Context Sensitivity Help, Autolink, Link Path
- 1.7Transformation Objects in Depth II Stored Procedure, Router, Sorter
- 1.8Local Variables Using local Variables Port evaluation
- 1.9Transformation Objects in Depth III Rank, Joiner
- 1.10Functions Built-in Functions User-Defined Functions
- 1.11Review Quiz Designer: Propagate attributes Sharing and Reusing Designer Objects Reusable transformations Working with shortcuts
- 1.12Transformation Objects in Depth IV Union, Normalizer Java Transformation SQL Transformation HTTP Transformation Transaction Control
- 1.13Mapplets Designer: Foreign Key Relationships Transformation Objects in Depth V Update Strategy, Sequence Generator
- 1.14Slowly-Changing Dimensions Review Quiz Workflow Manager Menus & tools 5 steps to creating a workflow Session properties
- 1.15Workflow Monitor Interface Controlling workflows and tasks Viewing logs & session properties Gantt Chart View & Task View
- 1.16Workflow Tasks Command Email Decision Timer Control Event Raise & Wait
- 1.17Worklets Parameters & Variables In mappings In sessions and workflows Parameters files
Instructor
