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

How to clean the datastage repository?

1182

---

On which Dimension Table you implemented SCD Type in your Project

2113

---

table actions available in oracle connector?

1658

---

Difference between sequential file and data set?

1261

---

What is data partitioning?

1269

---

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

1139

---

What is the difference between validated and compiled in the datastage?

1375

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5193

---

in oracle target stage when we use load option and when we use upsert option?

2323

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1352

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4098

---

What is meta stage?

1242

---

Can you explain players in datastage?

1249

---

What are the functionalities of link partitioner?

1067

---

whom do you report?

1986

---