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 / 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 |
Post New Answer View All Answers
Explain lookup transformation in informatica
How many types of sessions are there in informatica.please explain them?
What are the measure objects?
How to join three sources using joiner?
where to store informatica rejected data? How to extract the informatica rejected data?
What is the way to execute pl/sql script using informatica mapping?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is enterprise data warehousing?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How to start a workflow using pmcmd command?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is target designer and target load order?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the different types of olap? Give an example?