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

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

10 Answers   Wipro,

---

How do you get log info into a file?

1 Answers  

---

how CAN we remove duplicates in dataset?

2 Answers   IBM,

---

Nls stands for what in datastage?

0 Answers  

---

How and where you used hash file?

0 Answers  

---

whom do you report?

0 Answers   NTT Data,

---

What is exact difference between Parallel Jobs and server Jobs..

7 Answers   IBM,

---

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,

---

what is the use of invokation id

2 Answers   IBM,

---

how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction

1 Answers   Reliance,

---

source contains 2 columns comes to target 4 columns how

1 Answers   IBM,

---

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

0 Answers   Wipro,

---