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
- 11781 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 |
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
Does an informatica transformation support only aggregate expressions?
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
What is Cognos script editor?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
How can repository reports be accessed without sql or other transformations?
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
what is workflow varible
If we have lookup table in workflow how do you trouble shhot to increase performance?
WHat all joins are there in Source Qualifier?
Teradata 
