Answer Posted / prasad

select empno,sal,deptno from tablename where (sal,deptno)in(select max(sal),deptno from tablename group by deptno)



in datastage

oracle stage->aggregator stage->lookup->dataset

What is the use of datastage director?

1021

---

how to add a new records into source?

2005

---

how to write server Routine coding?

2132

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2270

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1557

---

what is the use of surogate key in datastage

2312

---

Describe stream connector?

1312

---

What are some different alternative commands associated with "dsjob"?

1171

---

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

1544

---

project Steps,hits, Project level HArd things,Solved methods?

2138

---

What are the differences between datastage and informatica?

1183

---

Triggers,VIEW,Procedures

1227

---

What is the precedence of stage variables,derivations, and constraints?

1086

---

what is use of SDR function?

5179

---

root tree will find which is server job and which is parallel job?

1976

---