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
- 11384 Views
- Amdocs, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / siva
In expression add one column and make it output(sal1) and
salary port as input only.
We will make use of a function named cume(salary) to solve
our problem, rather using any complex mapping
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / 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 |
Answer / suresh
we have a predefined function in informatica CUME()
in expression t/r. donot struggle for writing logics
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Answer / priyank
Var_SAL=IIF(Var_SAL=0,SAL,Var_SAL+SAL)
Out_SAL=Var_SAL
| Is This Answer Correct ? | 1 Yes | 0 No |
How might one distinguish in the case of mapping is right or not without associating session?
How is union transformation utilized?
what is shortcut in informatica? difference between shortcut,reusable object?
Explain how to import oracle sequence into informatica?
Why the workflow is failed after running two hours in informatica?
What is an Integration service in Informatica?
What if the source is a flat-file?
without dynamic lookup transformation how to insert new rows and update existing rows?
Explain the use of aggregator cache file?
What is partioning?how many types of partinings are there
what is left outer join?
Why we use stored procedure transformation?
Teradata 
