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
- 12124 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
What are the different types of transformation available in informatica.
Slowly changing dimensions, types and where will you use them
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
tell me 5 session failure in real time how can you solve that in your project?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
If informatica has its scheduler why using third party scheduler?
How would you copy the content of one repository to another repository?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to update source definition?
What is repository manager?
How union transformation is used?
How can one identify whether mapping is correct or not without connecting session?
Why sorter is an active transformation?
What is an unconnected transformation?
