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

what r the transformations that r not involved in mapplet?

8 Answers   Wipro,

What is a joiner transformation and why it is an active one?

0 Answers  

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  




write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers   TCS,

scenario

1 Answers  

Tell me about Propagate functions in informatica

0 Answers  

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers   Logica CMG,

Define informatica repository?

2 Answers   Wipro,

How do you remove duplicate records in informatica? And how many ways are there to do it?

0 Answers  

What is data transformation manager process?

0 Answers  

For more Informatica Interview Questions Click Here
Categories