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

Define data aggregation?

0 Answers  

---

source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers   IBM,

---

What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,

---

Give example for FACTLESS FACT TABLE in real-time scenario.

4 Answers   TCS,

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

0 Answers   Wipro,

---

Hai..,in datastage how to explain project in interview?please explain any domain please.

1 Answers   Wipro,

---

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,

---

How many types of sorting methods are available in datastage?

0 Answers  

---

What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

5 Answers   IBM,

---

in oracle target stage when we use load option and when we use upsert option?

0 Answers  

---

Explain connectivity between datastage with datasources?

0 Answers  

---