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...

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000).
In the Target I want the following EmpID, Salary,
Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103,
3000, 6000). Please guide on how to build the mapping.

Answer Posted / suresh

we have a predefined function in informatica CUME()
in expression t/r. donot struggle for writing logics

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define filter transformation?

1097


What are the databases that informatica can connect to windows?

1052


Explain load alternative records / rows into multiple targets - informatica

1152


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.

1641


How to extract the informatica rejected data?

1220


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2745


Describe the impact of several join conditions and join order in a joiner transformation?

1063


lookup transformation with screenshots

4006


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2066


Explain lookup transformation in informatica

1073


How to use procedural logic inside infromatica?

1236


Can informatica load heterogeneous targets from heterogeneous sources?

1187


In how many ways we can create ports?

1123


What is dimensional table? Explain the different dimensions.

1172


How to start a workflow using pmcmd command?

1251