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
- 11004 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 |
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
how can u approach u r client
What do think which one is the better joiner or look up?
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
what is the significance of newlookup port in dynamic look up
explain about lookup t/r?
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
How to compare Source and Target table, without using dynamic lookup?
How to load a relational source into file taget?
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
How to prepared lld.can any one tell me detailed explanetion.
Teradata 
