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
- 11560 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
Which files are created during the session rums by informatics server?
What is a grid in Informatica?
While migrating the data from one environment to another environment how would you manage the connections?
Suppose we do not group by on any ports of the aggregator what will be the output?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What does role playing dimension mean?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Explain the pipeline partition with real time example?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is a transaction control transformation?
What is depict expression change?
How to extract sap data using informatica? What is abap? What are idocs?
Design a mapping to load a target table with the following values from the above source?
How to go to the older version for a mapping?
What is the need of etl tools?
