Interested to Buy Any Domain ? << Click Here >> for more details...
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000
4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement
is like this id name sal up_sal,1 aa 1000 null,2 bb 2000
1000, 3 cc 3000 2000
4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on
so how can i get it plez reply for this as soon as possible
, thanks in advanced
- 9 Answers
- 11872 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapnil
use CUMM(sal) function in expression like this:
id(i/o)
sal(i/o)
cum_sal(v)= cumm(sal)
up_sal= iif(sal=cumm_sal, NULL, cumm_sal)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain about cumulative Sum or moving sum?
what is unit testing?tell me proceedure
How to implement security measures using repository manager?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Write the different tools in the workflow manager?
what is Active lock explain
Explain transaction control transformation in informatica
What do you mean incremental aggregation?
what is mean by complex business rule ?
What you know about transaction control transformation?
What is source qualifier transformation in informatica?
wat are deployement groups in informatica, how it will be used for developers
What does reusable transformation mean?
How do you migrate data from one environment to another?
What is a mapplet/worklet in informatica?
