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
Tell me about Propagate functions in informatica
In warehouses how many schemas are there?
Quickly characterize reusable change?
Informatica settings are available in which file?
Enlist the tasks for which source qualifier transformation is used.
What does cheating measurement mean?
What is informatica?
Scheduling properties,whats the default (sequential)
Define mapplet?
Different qualification between a related rotate toward the sky and isolates look upward?
In informatica workflow manager, how many repositories can be created?
which one is better performance wise joiner or look up
What do you understand by SOA of Informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is the function of look up transformation?