Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 11975 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
Can we update a target table (without primarykey) by using update strategy transformation?
What are the different transaction levels available in transaction control transformation?
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
Explain the different kinds of facts.
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
Diffrence between 7.1,8.1 and 8.6
What are the different types of repositories created using informatica?
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
What is data merging, data cleansing and sampling?
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
State the limitations where we cannot use joiner in the mapping pipeline?
What are the different types of transformation available in informatica.
Teradata 
