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
What do you mean by filter transformation?
what is mean by complex business rule ?
What are the transformations that are not supported in mapplet?
design of staging area?
Explain what are the different versions of informatica?
Which transformation should we use to normalise the COBOL and relational sources?
What is intricate mapping?
What is mapping debugger?
Performance tuning in UNIX for informatica mappings?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is a rank transform?
have u done any performance tuning? how u ll do?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is union transformation in informatica?