Answer Posted / raghunath

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

it is working.

What are the areas of application?

1152

---

How can we improve performance of data stage jobs?

1019

---

Define project in datastage?

1103

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1422

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1508

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3250

---

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1505

---

What are the steps required to kill the job in Datastage?

1218

---

What is orabulk stage?

1054

---

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

1083

---

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

2270

---

How do you register plug-ins?

970

---

What are the types of containers?

1243

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2239

---

What is active and passive stage?

1418

---