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
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
in what type of scenario bulk loading and normal loading we use?
All active transformations r passive or not?
Differentiate between router and filter transformation?
What is predefined event?
can we use bulk loading when we use look in mapping
What are the components of workflow manager?
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
Using Expression transformation how to remove duplicate records from a relational source?
How do you implement configuration management in Informatica?
What is the difference between warehouse key and surrogate key?
how to use incremental load?
how can one eliminate dupliacte data with out using distinct option?