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

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

1 Answers   Wipro,

What is the target load order?

3 Answers   HCL, Informatica,

difference between shortcut and reusable transformation?

2 Answers  

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  

List the transformation in informatica.

1 Answers   TCS,




which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 Answers  

What is partioning?how many types of partinings are there

2 Answers   HCL,

how you will maintain version?

3 Answers   CTS, TCS,

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,

write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh

5 Answers   Accenture,

For more Informatica Interview Questions Click Here
Categories