Answer Posted / 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

Could anyone give brief explanation bout datastage admin

2350

---

What a datastage macro?

1054

---

What are the functionalities of link partitioner and link collector?

1005

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2054

---

What is the differentiate between data file and descriptor file?

1355

---

how do u catch bad rows from OCI stage? And what CLI stands for?

2795

---

How many types of hash files are there?

1177

---

Which warehouse using in your datawarehouse

2182

---

Can you explain kafka connector?

1303

---

Demonstrate experience in maintaining quality process standards?

2542

---

What is the difference between orabulk and bcp stages?

1022

---

Why do we use link partitioner and link collector in datastage?

1131

---

Difference between sequential file and data set?

1194

---

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2369

---

What is the difference between the local container and shared container?

1093

---