1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

Question Posted / sri.sra2007

Answers were Sorted based on User's Feedback



i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 10..

Answer / radhakrishan

Use the cume function in salary port in expression transformation. It will give the cumulative values in target.

for reference
https://community.informatica.com/solutions/calculate_move_sum_avg

Is This Answer Correct ?    15 Yes 0 No

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 10..

Answer / kriishh

take SQ->EXP.In expression create a variable port
V_CUM_SAL=V_CUM_SAL+SAL
then create a new o/p port o_sal=V_CUM_SAL

Is This Answer Correct ?    13 Yes 0 No

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 10..

Answer / abhinaw prakash

You can make use of Variable ports for storing values
coming as input.For output you can compare values and give
the output.

the expression for output will look something like
IIF(Input_sal=v_prev_sal,v_prev_sal,input_sal+v_prev_sal)

Is This Answer Correct ?    3 Yes 0 No

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 10..

Answer / jayachandra

use expression transformation here take two variable ports
one varaible port as v_sal and one more variable port as
o_sal and assign as o_sal=o_sal+sal
and write condition csum as

iif(sal=v_sal,o_sal+sal,o_sal)

Is This Answer Correct ?    2 Yes 1 No

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 10..

Answer / sameer

First we uses cumulative function and second we can use expression transformation then we can calculate

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

How to implement security measures using repository manager?

0 Answers  

What is IQD file?

1 Answers  

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  

Target is zero file and how can you send the email?

2 Answers   Bank Of America,




lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

What is critical mapping?

2 Answers  

What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

5 Answers   CTS,

How to extract the informatica rejected data?

0 Answers  

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

What is a design?

1 Answers  

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories