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 / nirosha g

Use Expression Transformation for this.
Create variable port after the two input ports:
v_cumm_sal = v_cumm_sal+sal;
o_cumm_sal = v_cumm_sal;

Connect The ports id,sal and o_cumm_sal to target

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me about Propagate functions in informatica

922


In warehouses how many schemas are there?

1073


Quickly characterize reusable change?

1119


Informatica settings are available in which file?

990


Enlist the tasks for which source qualifier transformation is used.

1040


What does cheating measurement mean?

1051


What is informatica?

1155


Scheduling properties,whats the default (sequential)

1955


Define mapplet?

1008


Different qualification between a related rotate toward the sky and isolates look upward?

986


In informatica workflow manager, how many repositories can be created?

1361


which one is better performance wise joiner or look up

1093


What do you understand by SOA of Informatica?

989


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1579


What is the function of look up transformation?

1123