Hi, If you are not sure about the id's sorting order count = count

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

Question Posted / ankit kansal

9 Answers
11864 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

Please Help Members By Posting Answers For Below Questions

generate date / time dimension in informatica

1161

What is the difference between Active and Passive transformation?

1220

What is the use of code page?

1172

What are the types of schemas we have in data warehouse.

1004

wat are deployement groups in informatica, how it will be used for developers

1771

How we can use union transformation?

1104

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1916

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2107

What is rank transformation?

1035

What is the advantage of informatica?

1124

While migrating the data from one environment to another environment how would you manage the connections?

1133

What is update strategy transform?

1162

What is an Integration service in Informatica?

1191

What are the different types of repositories created using informatica?

1169

Explain target update override in informatica

1190