Answer Posted / vinod upputuri

In order to collect the duplicate values:

first cal the count output col in aggregator stage
group by col.
aggregator type: count rows.
count output col..

next, use the filter stage to separate the multiple occurrence.

finally, use the join stage or lookup stage to map the two
tables join type INNER ..

then u can get the desired output..

What is staging variable?

1029

---

What are the various kinds of the hash file?

1098

---

How do you run datastage job from the command line?

1030

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2003

---

How do you import and export the datastage jobs?

1110

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2677

---

What is the differentiate between data file and descriptor file?

1307

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2106

---

How many types of views are there in a datastage director?

1233

---

Difference between in process and inter process?

1164

---

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

1476

---

How many types of sorting methods are available in datastage?

1020

---

Explain the importance of surrogate key in data warehousing?

1129

---

What are the main features of datastage?

1208

---

how to add a new records into source?

1937

---