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.
- 5 Answers
- 11002 Views
- Amdocs, I also Faced
- E-Mail Answers
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
How do you update the records with or without using update strategy?
What are session parameters ? How do you set them?
Clarify the utilization of aggregator cache record?
Explain why we use partitioning the session in informatica?
In informatica workflow manager, how many repositories can be created?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is a filter transformation and why it is an active one?
Which transformation should we use to normalise the COBOL and relational sources?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
update strategy transformation in informatica
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the different lookup cache(s)?
What is deployment group?
What are batches?
What is xml source qualifier transformation in informatica?
