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.

Answers were Sorted based on User's Feedback



My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following E..

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

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following E..

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

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following E..

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

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following E..

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

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following E..

Answer / priyank

Var_SAL=IIF(Var_SAL=0,SAL,Var_SAL+SAL)
Out_SAL=Var_SAL

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  


What is an expression transformation?

0 Answers  


where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  


My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,


what are the unix commands to start the wrk flow ?

4 Answers   Accenture, TCS,






How to recover sessions in concurrent batches?

3 Answers  


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  


what is service oriented architecture in Informatica 8 version

1 Answers   Cap Gemini, IBM, Systech, TCS,


My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,


What is a difference between complete, stop and abort?

0 Answers  


How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,


write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,


Categories