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 / rambhupal
by using variable port also we can solve this.create one variable port and output port,assign that v_count=v_count+salary,for out port o_count=v_count
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the meaning of decode in informatica?
What is the use of transformation?
can we override a native sql query within informatica? Where do we do it?
Differences between connected and unconnected lookup?
How to extract sap data using informatica? What is abap? What are idocs?
Name the different lookup cache(s)?
tell me 5 session failure in real time how can you solve that in your project?
Explain the features of connected and unconnected lookup.
What are the modules in Power Center
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How many types of sessions are there in informatica.please explain them?
How to load a Dimension ? and how to load a fact table?
How do you take back up of repository?
How to use pmcmd utility command?
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