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
- 11940 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
How do you convert single row from source into three rows into target?
What are the reusable transformations?
Difference between Data and Index Caches?
Target increases every day even though no new record was inserted
What's the layout of parameter file (what does a parameter file contain?)?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is workflow manager?
What is a mapplet/worklet in informatica?
How are the sources and targets definitions imported in informatica designer?
design of staging area?
What is dimensional table? Explain the different dimensions.
How to use procedural logic inside infromatica?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
what is mean by complex business rule ?
What are the types of caches in lookup?
