Course Overview
This Boot Camp for Developers Informatica PowerCenter 8.6/9.1 course teaches advanced mapping techniques and performance tuning and provides a thorough review of session partitioning features found in PowerCenter version 8.6/9.1.
Requirements
- Data processing experience
Target audiences
- Developers & Analysts
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 Sensitive 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 20. 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 Parameter files
Instructor
