Answer Posted / subbuchamala

For RMD Stage we need Grouping Keys, Add one extra hard coded Column to each Input records in previous stage.
DUMMY=1

In RMD Stage,
HASH partition on DUMMY, Sort DESC on Salary

and select DUMMY as Key in properties tab.
"Duplicate to Retain"=First.

then you will get only Highest Salart only from RMD Stage

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3139

---

Define ds designer?

1223

---

How you can fix the truncated data error in datastage?

1691

---

What is job control?

1052

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1459

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2054

---

What is the difference between informatica and datastage?

1158

---

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?

2160

---

How to read multiple files using a single datastage job if files have the same metadata?

1184

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

891

---

Have you used Unstructured data?

1275

---

Give an idea of system variables.

973

---

What are stage variables and constants?

1104

---

What is the difference between datastage and datastage tx?

1017

---

Why do we use exception activity in Datastage?

1242

---