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
- 11224 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
Can we create a Integration service without a Repository service and vice versa?
Can informatica load heterogeneous targets from heterogeneous sources?
What is DR strategy for Informatica project?
What is the Rank index port in Rank transformation?
What are the databases that informatica can connect to windows?
difference between informatica 8.1.1 and 8.6
Describe data concatenation?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What can we do to improve the performance of informatica aggregator transformation?
Quickly characterize reusable change?
What are the types of caches in lookup?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
have u done any performance tuning? how u ll do?
What are the new features of informatica 9.x in developer level?
