Answer / raghunath

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

it is working.

Answer / nagam

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

Answer / prasad

select * from Table_name where column_name in(select Column_name from table_name group by column_name having count(1)>1)


select deptno from emp where deptno in (select deptno from emp group by deptno having count(1)>1)

u will get only duplicate records

for Example:

deptno
----------
10
10
20
20
30
40
50

by using above query the o/p displays

deptno
--------------
10
10
20
20

HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

1 Answers   IBM,

---

What is APT_DUMP_SCORE?

2 Answers   IBM,

---

Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,

---

HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com

5 Answers   FIS,

---

In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?

2 Answers   Polaris,

---

What is the difference between account and directory options ?

0 Answers  

---

what is hash file

2 Answers   CTS, IBM,

---

How you can fix the truncated data error in datastage?

0 Answers  

---

I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

2 Answers  

---

which r the connectors used in san?

0 Answers  

---

how to create document in datastage?

1 Answers   Cap Gemini,

---

i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 Answers  

---