Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

Answer Posted / sameer

First we uses cumulative function and second we can use expression transformation then we can calculate

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can we override a native sql query within informatica? Where do we do it?

1072


what is Active lock explain

2730


How to improve the performance of a session using sorter transformation?

1095


Write the different tools in the workflow manager?

995


How can a transformation be made reusable?

1080


How can we update a record in the target table without using update strategy?

1090


What is dynamic cache?

974


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2077


How would you join a node to the already existing domain?

1068


what is INFORMATICA TESTING process

2229


What is Session and Batches?

1042


What are the tasks that source qualifier perform?

1033


What are the informatica performance improvement tips

1019


What are connected or unconnected transformations?

1052


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1591