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

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

---

Please tell me What is difference between 8.0 and 8.1

1 Answers   IBM,

---

What are constraints and derivations?

0 Answers  

---

What are the benefits of datastage?

0 Answers  

---

Terminate Activity

0 Answers   CTS,

---

On which interface you will be working as a developer?

0 Answers  

---

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

15 Answers   Scope International,

---

What is staging variable?

0 Answers  

---

how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers   Syntel, TCS,

---

How can we do null handling in sequential files

3 Answers   Reliance,

---

I have a few records just I want to store data in to targets cycling way how?

0 Answers   Polaris,

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers   CTS,

---