Answer Posted / amit

using hash partition technique, we can bring duplicate data(based on key columns) in one partition. Then in stage constraints filter out data with setting @inrownum = 1.

This will remove duplicate in transformer stage.

What are the components of datastage?

1063

---

What are the important features of datastage?

1048

---

What is "fatal error/rdbms code 3996" error?

1190

---

how to delete one row in target dataset

3061

---

What are the benefits of datastage?

1173

---

What are the different kinds of views available in a datastage director?

971

---

how many rows sorted in sort stage by default in server jobs

3929

---

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

887

---

How to reverse the string using unix?

3430

---

How to manage date conversion in Datastage?

1069

---

What a datastage macro?

1004

---

What is the difference between account and directory options ?

1111

---

Explain ibm infosphere information server and highlight its main features?

1034

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1192

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1028

---