Answer Posted / c raghavendra nivas

      
             -------removeduplicate(first)
source---copy                    ------funnel----output
             -------removeduplicate(last)

it works i did it
try if u want

if its a database you can do witha co-related sub query

what are the errors,warnings in datastage

2618

---

Differentiate between datastage and datastage tx?

1003

---

What is the difference between validated and compiled in the datastage?

1187

---

Can you explain link buffering?

1104

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2207

---

What are the types of views in datastage director?

1718

---

What is staging variable?

1026

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

864

---

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

1174

---

What are the primary usages of datastage tool?

1016

---

What are sequencers?

1055

---

If you want to use a same piece of code in different jobs, how will you achieve this?

1224

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1471

---

Explain ibm infosphere information server and highlight its main features?

1033

---

How many Key we can define in remove duplicate stage?

1309

---