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
- 11358 Views
- I also Faced
- E-Mail Answers
Answer Posted / nirosha g
Use an Expression Transformation connected to Source Qualifier
taking all the columns from source
In expression Transformation create two variable ports and one
output port after Input ports in same order
v_prev_sal = iif(id=1,NULL,prev_sal);
prev_sal = sal;
o_prev_sal = v_prev_sal;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the need for an etl tool?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is a filter transformation?
How can we update a record in the target table without using update strategy?
What is Session and Batches?
What is the surrogate key?
How to elaborate powercenter integration service?
What are the new features of Power Center 5.0?
Explain the aggregator transformation?
How we can use union transformation?
What is confirmed fact in dataware housing?
Tell me about Propagate functions in informatica
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is sorter transformation?
