Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

The flow of mapping will be like this, You will be using two expression transformation.Of which you need to make the first expression...

Getting Cumulative Sum

Consider the following employees data as source employee_id, salary 10, 1000 20, 2000 30, 3000 40, 5000 Design a mapping to load the ...

Design a mapping to load each product once into one table and the remaining products which are duplicated into another table.

This is the flow of transformations you need to follow, First you need to sort the data,for this use sorter. In expression transfor...

Unique Constraint error

Scenario :We have  insert else update mapping and we have look up transformation for target.When we are loading data to target  data shou...

Indirect file loading

First lets see how to do indirect file loading. 0)import a flat file and create a mapping to load the flat file data to target.The sour...

How to open a .bin file in informatica

Its very simple. Go to the workflow monitor window and select tools tab.In that select import log and navigate to the folder where the .bin...

What's the difference between Stopping and Aborting the session

Jon and sham are very good friends. Jon is working as a informatica developer and he is very good at it. Sham wants to learn informatica an...