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
- 11626 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 all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are session parameters ? How do you set them?
Write the unconnected lookup syntax?
What is an expression transformation?
difference between repository database and repository service?
What is a predefined event?
What is a surrogate key?
What is difference between a gateway node and worker node?
Explain joiner transformation in informatica
What can we do to improve the performance of informatica aggregator transformation?
What is a filter transformation and why it is an active one?
draw informatica architecture 8.6 ?
What are the advantages of informatica?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is session task and command task?
