Informatica PowerCenter 10.x Foundation | Boot Camp for Developers

Course Code: TTINFDEV4

Skill Level: Introductory

Duration: 4 Days

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 Objectives

NOTE: The Informatica Training Series is independent-format training that can be tuned and adjusted to best meet your needs. Our materials are flexible, comprehensive, and are always instructed by a senior instructor with a deep understanding of Informatica and its most current features, benefits and functionality in a wide array of uses. This is not Official Informatica Training.

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

Lab - Mapplets

User Defined Functions

Setup

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

Workspaces

Simple Workflow

Creating
Session setup

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.

Raise the bar for advancing technology skills

Attend a Class!

Live scheduled classes are listed below or browse our full course catalog anytime

Special Offers

We regulary offer discounts for individuals, groups and corporate teams. Contact us

Custom Team Training

Check out custom training solutions planned around your unique needs and skills.

EveryCourse Extras

Exclusive materials, ongoing support and a free live course refresh with every class.

Mix, Match & Master!
2FOR1: Two Courses, One Price!
Enroll in *any* two public courses (for 2023 *OR* 2024 dates!) by December 31, for one price! Learn something new, or share the promo!

Click for Details & Additional Offers

Learn. Explore. Advance!

Extend your training investment! Recorded sessions, free re-sits and after course support included with Every Course

Gain the skills you need with less time in the classroom with our short course, live-online hands-on events

Trivera QuickSkills: Free Courses and Webinars

Training on us! Keep your skills current with free live events, courses & webinars

Trivera AfterCourse: Coaching and Support

Expert level after-training support to help organizations put new training skills into practice on the job

The voices of our customers speak volumes

Great job overall. Great communicator and explained complex concepts in a simple, easier to understand format.

Jeremy G

Best programming class I've ever been in, head and shoulders above any thing I took in college as part of a computer science degree. The instructor was thorough and very detailed, he was very good abut explaining all possible scenarios a situation would apply to. The way the albs were structured and the class was conducted was very good for interaction and hand on learning.

Danish J

Instructor was beyond phenomenal. He had an in depth knowledge of the course material and always ensured that everyone understood what was being discussed. I really enjoyed the mix of theory and practical examples of each part of the course.

Cillian M

First time in my life I have attended remote class and I find it great. Personally I don't feel there is any area which require improvement!

Rishi M

The instructor was clearly knowledgeable about Java and programming in general. He was very attentive to every student's individual needs and constantly encouraged questions, concerns, student issues to be raised and addressed each one thoroughly.

Mark M

A very good balance of teaching time to lab time. I've done other courses that I found to be much lighter on content and heavy on labs to waste time. This was a refreshing change of pace.

Adam G

Both the instructor and the course material were very thorough - the course material has many helpful references - the labs were well laid out, making it easy to learn from and get done on time

Steve C.

Excellent detail about the Spring framework which directly relates to my role as a senior engineer. I found the content and style to be very enjoyable, and would encourage me to ask questions where previously I might not have paid much attention, eg. pom version numbers / spring starters being imported. The focus on the different styles of unit testing was also excellent and I would plan to incorporate in day to day work.

Edward K

Excellent training. Even though it was online, I did not have any issues understanding or getting the answers for the questions I had. The lab exercises are interesting to apply what was learnt. Overall very good training. Thank you!

Anitha

Special Offers
Limited Offer for most courses.

SAVE 50%

Learn More