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
- 10440 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
How to extract sap data using informatica?
How to use procedural logic inside infromatica?
Why update strategy and union transformations are active?
How to go to the older version for a mapping?
Parameter and variable differences
Did u used latest transformations of 8.6.0? for what?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Differentiate between router and filter transformation?
How to configure mapping in informatica?
How can you differentiate between powercenter and power map?
What is the way to execute pl/sql script using informatica mapping?
What is a sequence generator transformation?
What is meant by LDAP users?
Explain lookup transformation is active in informatica
