Course Overview
The Informatica PowerCenter Boot Camp for Developers is a four-day, comprehensive foundation class teaches the fundamentals of the Informatica PowerCenter 10.x platform through lecture and numerous integrated hands-on lab exercises. Students will gain a clear understanding of the product and acquire a solid foundation needed to make them a successful PowerCenter developer.
Course Prerequisites
This course is geared for developers new to Informatica Power Center.
Course Agenda
Day One
- Getting Started
- Course Objectives
- Introduction to Informatica PowerCenter
- Components & Architecture
- Basic Concepts
- Live Demo: creating and debugging a mapping
- Designer Overview
- Interface
- Folders
- Workspaces
- Concepts
- Sources and Targets
- Mappings
- Lab - Source and Target Definitions, Simple Mapping
- Transformation Objects in Depth I
- Transformations Objects Overview
- Source Qualifier
- Expression Transformation
- Aggregator Transformation
- Filter Transformation
- Lab - Expression, Aggregator, and Filter Transformations
Day Two
- Review Quiz
- Working with the Designer
- Layout
- Link Path
- Compare Objects
- Working with Transformations
- Using the Debugger
- Debugging process and strategies
- Discard Data Option
- Flow Control
- Breakpoints
- Evaluate expressions
4. Working with Flat Files and Joiner Transformation
- Importing and editing flat file sources/targets
- Flat file data-types
- Joiner Transformation
- Lab - Joining flat file and relational data
- Transformation Objects in Depth II
- Lookup Transformation
- Stored Procedure Transformation
- Rank Transformation
- Using built-in functions
- Lab - Lookup and Rank Transformations
- Local Variables
- Overview
- Using local Variables
- Port evaluation
- Transformation Objects in Depth III
- Sorter Transformation
- Router Transformation
- Designer Tips
- Auto Link
- Propagate Attributes
- Lab - Local variables, Sorter, and Router Transformations
Day Three
- Review Quiz
- Sharing and Reusing Designer Objects
- Reusable transformations
- Working with shortcuts
Mapplets
- User Defined Functions
- Transformation Objects in Depth IV
- Union
- Normalizer
- Lab - Normalizer and User Defined Functions
- Transformation Objects in Depth V
- Java Transformation
- SQL Transformation
- HTTP Transformation
- Transaction Control
- Slowly-Changing Dimensions
- Lab - Type 1 – Slowly Changing Dimension
Day Four
- Review Quiz
- Workflow Manager
- Simple Workflow
- Workflow Monitor
- Interface
- Gantt Chart View
- Task View
- Controlling workflows and tasks
- Viewing logs & session properties
- Workflow Error Handling
- Sessions
- Link Conditions
- Lab - Simple Workflow and Error Handling
- Complex Workflows
- Scheduler
- Reusability
- Wizard
- Workflow Tasks in Depth
- Email Task
- Command Task
- Decision Task
- Timer Task
- Event Raise & Wait Task
- Control Task
- Worklets
- Lab – Complex Workflow
- Parameters & Variables
- In Mappings
- In Sessions
- In Workflow
- Integration Service
- Lab - Mapping Parameters and Variables
Course Materials
Each student will receive a Student Guide with course notes, code samples, software tutorials, diagrams and related reference materials and links (as applicable). Our courses also include step by step hands-on lab instructions and and solutions, clearly illustrated for users to complete hands-on work in class, and to revisit to review or refresh skills at any time. Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.