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
- 11559 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
Hi,
If you are not sure about the id's sorting order
count = count+1
v_sal = IIF(count=1,null,v_prev_sal)
v_prev_sal = sal
out_sal = v_sal
http://deepinopensource.blogspot.com/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the main issues while working with flat files as source and as targets ?
What is mapplet in informatica?
Explain Dataware house architecture .how data flow from intial to end?
Separate from a database, an information bazaar, and an information stockroom?
how many types of dimensions are available in informatica?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What do you mean by worklet?
without table how to come first record only in oracle?
What are the differences between source qualifier and joiner transformation?
Explain the informatica workflow?
What is an aggregator transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Differentiate between Load Manager and DTM?
How to create or import flat file definition in to the warehouse designer?
