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
Answer Posted / 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 |
Post New Answer View All Answers
What are the tuning techniques you applied during your last project
Under which circumstances, informatica server creates reject files?
What does “tail –f” command do and what is its use as an Informatica admin.
Explain lookup transformation is active in informatica
Explain dynamic target flat file name generation in informatica
Enlist few areas or real-time situations where informatica is required.
Repository user profiles
What are the new features of informatica 9.x at the developer level?
wf dont have integration severances how you can run?
Can you generate sequence numbers without using the sequence generator transformation?
What all are steps in up gradation of Informatica server?
Mention some types of transformation?
How we can use union transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you