Fusion Blog

EBS Blog


Contact Us

  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 1 / 5

Star ActiveStar InactiveStar InactiveStar InactiveStar Inactive

Apps2Fusion offers Informatica Training Programs to developers who are new to the world of Informatica PowerCenter 9.x. By taking up Informatica PowerCenter 9.x Developer Training you will become the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools, performing tasks such as creating transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data. You will be able to develop cleansing, formatting, sorting and aggregating procedures. You will learn how to use routers, update strategies, parameters /variables and overrides. You will know about many different types of lookups, such as cached, persistent, dynamic and multiple row returns. Workflow tasks will be created to define a set of instructions for executing the ETL. 


By the end of this training you will learn to: 

Use Informatica Support to resolve questions and problems with PC9.x.

Use PowerCenter 9.x Designer to build mappings that extract data from a source to a target, transforming it as necessary.

Use PowerCenter transformations to cleanse, format, join, aggregate and route data to the appropriate targets

Perform error handling/trapping using PowerCenter mappings

Use PowerCenter 9.x Workflow Manager to build and run a workflow which executes a sessions associated with a mapping

Design and build simple mappings and workflows based on essential business needs.

Perform basic troubleshooting using PowerCenter logs and debugger. 

Course Contents

Day 1

An Overview of Informatica PowerCenter 9

Overview of PowerCenter covering areas such as the

Architecture, Terminology, Tools GUI, Mappings,

Transformations, Sessions, Workflows and Workflow Monitor


ETL Fundamentals

How to create:

  • Flat file and relational Sources using the Source Analyzer
  • Flat file and relational Targets using the Target Developer
  • Mappings using the Mapping Designer
  • Workflows using the Workflow Designer

Monitor the workflow using the Workflow Monitor

Preview Target Data using the PowerCenter Designer


Trouble Shooting

Understand PowerCenter Log files

Use PC log files to:

View and look up error messages

Correct mapping and workflow errors

Day 2

PowerCenter Transformations, Tasks and Reusability

Define list of PC Designer Transformations and Workflow Tasks

Clarify Active vs. Passive Transformations

Use the Expression Transformation and Editor in a mapping which applies a file list to load multiple flat files into a stage table utilizing expression and filter transformations to format and screen erroneous customer data

Use Reusable Designer Transformations to apply same formatting logic to Employee records


Joins and Link Conditions

Define Joins

Clarify Heterogeneous vs. Homogeneous Joins

Use a Joiner Transformation to join relational and flat file sources

Use the Source Qualify to join two relational sources

Make use of Link Conditions to execute one session when the first finishes successfully.


Using the Debugger

Outline Debugger Interface

Show creation of a break point

Show ‘Evaluate the Expression’ functionality

Re-Execute mapping with different values

Day 3

Sequence Generators, Lookups and Caching

Define the Sequence Generator

Define the Lookup Transformation

Understand the different types of Lookups

Clarify Lookup Caching

Use a Flat File Lookup to add data to a relational target.

Build a Dates Lookup Cache for use in determining start and end dates of target records

Utilize Event Wait, Event Timer and Email Tasks to wait for flat files and email users upon successful/failed load.


Update Strategies, Routers and Overrides

Build a mapping that uses Update Strategies and Routers to determine insert/update logic for a target. Overrides will be used for incremental (daily) loading of the target.


Sorter, Aggregator, Unconnected Lookups, Mapping Parameter/Variables and Mapplets/Worklets

Define Sorter Transformation

Detail Aggregator Transformation and Aggregate Functions

Explain Unconnected Lookups and how they are called.

Describe Mapping Parameters/Variables and initialization priority

Outline Mappets and Worklets

Use these Transformations to create a mapping which loads records from warehouse Dimension tables to a Fact table.

Day 4

Workflow Variables and Tasks

Use PC workflow variables to pass information from one point in a workflow to another

Use an Assignment task to establish the value of a workflow variable within a workflow

Use a decision task to set criteria by which the workflow will decide which execution branch to follow


Parameter Files and Command Tasks

Use a Parameter file to make mappings and workflows more flexible by defining values for mapping variables, source files, database connections for sessions and workflow log files

Use Command Tasks to run scripts to rename and move files 


Dynamic Lookups and Error Logging/Handling

Use Dynamic Lookup, Router and Update Strategy in a mapping do a lookup on the target table and determine if the record should be an insert, update or logged to a file as an error.

Use PowerCenter Best Practices to create a mapping to trap fatal and non-fatal errors.

Day 5

More Lookup Functionality

Create a Multiple Row Return Lookup, use Aggregators and Expressions to count the number of orders a Customer has as

well as total the sales for that customer. Add those values to a target.


Mapping Design Workshop

Business requirement details will be provided so that the student can design and build their own mapping necessary to load a Promotions Aggregate table. The workshop will provide Velocity Best Practices documents that can be used to determine the correct logic for the mapping 


Workflow Design Workshop

Business requirement details will be provided so that the student can design and build their own workflow necessary to load all staging tables in a single workflow. The workshop will provide Velocity Best Practices documents that can be used to determine the correct logic for the workflow.


Training Hours

Time: 12:00 NOON GMT | 07:00AM EST | 4:00AM PST | 6:00AM CST | 5:00AM MST | 5:30PM IST  | 01:00PM GMT+1


Database developers with little or no experience of PowerCenter. 

{jcomments off}

Database developers with little or no experience of PowerCenter.


About the Author


Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  May 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
       1  2
  3  4  5  6  7  8  9

Enquire For Training

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner