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 is the different lookup cache(s)?
What is resilience time?
What happens when a session fails and you click on recover?
is it possible to index the data in cache of lkp transformation ?
What are the components of the workflow manager?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
complex mapping ur project u r invlve can u explain and give real time example give me ?
Why do we need informatica?
While migrating the data from one environment to another environment how would you manage the connections?
Explain in detail scd type 2 through mapping.
What is rank transform?
What is the commit type if you have a transaction control transformation in the mapping?
Is it possible to use a client with different version than that of its Informatica server?
what is the size of your data warehousing?