Answer / srinivas

We can do this by using the sort stage.

Specify the key columns what ever the you are sort.

Specify column name sort specifications
For example i have 3 columns data like below

Name score rank

abc 85 1
bcd 74 3
abc 82 2
bcd 67 4

When u r sort based on first two colmns

u have to specify two colmn names and specificaton

Like: Name Asc, Score Dsc.

Then u will get the output like below.

Name score rank
abc 85 1
abc 82 2
bcd 74 3
bcd 67 4

what is parameterset?

4 Answers   Wipro,

---

Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers   HCL, Scope International,

---

How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  

---

Define ds designer?

0 Answers  

---

what r the stages mostly used in realtime scenarios

4 Answers   HCL, IBM,

---

i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance

2 Answers   IBM,

---

EXPLAIN SCD

0 Answers   CTS,

---

what is the difference between datasatge and datastage TX?

6 Answers  

---

2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?

1 Answers  

---

How do you generate sequence number in datastage?

0 Answers  

---

what is the difference between 7.1,7.5.2,8.1 versions in datastage?

3 Answers   IBM,

---

What is the difference between account and directory options ?

0 Answers  

---