Answer Posted / raghunath

select empno from emp group by empno having count(empno)>1;

it is working.

What is aggtorec restructure operator?

1427

---

What are the processing stages?

1087

---

Explain the importance of surrogate key in data warehousing?

1175

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

997

---

Name the third party tools that can be used in datastage?

1069

---

What is the difference between Datastage 7.5 and 7.0?

1088

---

what is the custome stage in datastage? how can we impliment that one? plz tell me

2350

---

What is datastage?

1071

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2962

---

Explain usage analysis in datastage?

1150

---

Define ds designer?

1257

---

What is the difference between datastage and datastage tx?

1050

---

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

1518

---

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?

2195

---

What is the purpose of pivot stage?

1156

---