Answer Posted / 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 a ds designer?

1111

---

What is a merge in datastage?

1340

---

How do you generate sequence number in datastage?

1136

---

What are routines in datastage? Enlist various types of routines.

1152

---

how can we create rank using datastage?what is the meaning of rank?

8845

---

What are some prerequisites for datastage?

1164

---

What is the different type of jobs in datastage?

1022

---

describe the Steps to confiure a Qlogic switch

2432

---

how to implement scd2 in datastage 7.5 with lookup stage

5657

---

What are the main features of datastage?

1347

---

What are system variables and sequencers in datastage

1174

---

What are the enhancements made in datastage 7.5 compare with 7.0?

1205

---

Enlist various types of routines in datastage.

1325

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

2493

---

How do you remove duplicate values in datastage?

1191

---