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

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

1041

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2403

---

Explain Quality stage?

1085

---

How do you generate sequence number in datastage?

1023

---

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

1018

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1331

---

Differentiate between operational datastage (ods) and data warehouse?

1115

---

How you can fix the truncated data error in datastage?

1671

---

What are data elements?

1100

---

How to read the length of word in unix?

1310

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

1020

---

What are iconv and oconv?

1178

---

How do y read Sequential file from job control?

15789

---

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

2063

---

how to export or import the jobs in .ISX file

1132

---