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
- 11350 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 is different between the data warehouse and data mart?
What is sq transformation?
What will be the approach?
Enlist few areas or real-time situations where informatica is required.
What is a filter transformation?
What is the procedure for creating independent data marts from informatica 7.1?
What is olap (on-line analytical processing?
What is the format of informatica objects in a repository?
How do you take back up of repository?
What is the scenario which compels informatica server to reject files?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the differences between oltp and olap?
How to create or import flat file definition in to the warehouse designer?
What are the differences between source qualifier and joiner transformation?
