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

client know skid info?

0 Answers   NTT Data,

---

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,

---

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,

---

Explain the scenarios where sequential file stage runs in parallel?

3 Answers   Accenture,

---

What is the difference between odbc and drs stage?

0 Answers  

---

What is the flow of loading data into fact & dimensional tables?

0 Answers  

---

pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 Answers  

---

HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  

---

how many write modes are there in ds

2 Answers   IBM,

---

What are the stages in datastage?

0 Answers  

---

what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,

---

Can you explain tagbatch restructure operator?

0 Answers  

---