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 / abhinaw prakash

You can make use of Variable ports for storing values
coming as input.For output you can compare values and give
the output.

the expression for output will look something like
IIF(Input_sal=v_prev_sal,v_prev_sal,input_sal+v_prev_sal)

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is event and what are the tasks related to it?

1203


explain abt ur project architecture?

2232


what is song in infrmatica...?

2320


What is a grid in Informatica?

1116


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2198


what is size of u r database?

2365


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1987


What is aggregator transformation in informatica?

1004


What is parallel processing in informatica?

1790


What are the guidelines to be followed while using union transformation?

1207


How do you set a varible in incremental aggregation

1944


What is joiner transformation in informatica?

1100


how tokens will generate?

2249


what is Active lock explain

2857


What is an aggregator transformation?

1144