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
- 11423 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
What are the designer tools for creating transformations?
generate date / time dimension in informatica
Design a mapping to load a target table with the following values from the above source?
What all join we can perform in LOOKUP transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is the need for an etl tool?
How many number of sessions can one group in batches?
What is data transformation manager process?
In informatics server which files are created during the session rums?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Can we get 1st record through Informatica(without sequence number).
As union transformation gives UNION ALL output, how you will get the UNION output?
define galaxy repository in informatica
What is the way to execute pl/sql script using informatica mapping?
