Answer / suraj kedia

Hi Sankar...
The methods as told by u r correct but i guess sree has
asked about finding duplicate records and the way to delete
them in oracle not in informatica.

So, the query to find out the duplicate records in a given
table (e.g. emp table) is as below:

select * from emp where empno in (select empno from emp
group by empno where count(*) >1);

Explanation:
============
See, in EMP table there are total 14 records out of which
only empno is unique,rest all fields can be repeated, so the
empno which are repeated more than once are duplicate
records & the above query shows the same.

Query to delete duplicate records;

delete from emp where rowid not in (select max(rowid) from
emp group by empno);

OR

delete from emp where rowid not in (select min(rowid) from
emp group by empno);

OR

delete from emp e1 where rowid < (select max(rowid) from emp
e2 where e1.empno=e2.empno);

OR

delete from emp e1 where rowid > (select min(rowid) from emp
e2 where e1.empno=e2.empno);

Answer / sankar

repet(more then one time) the rows is duplicate rows,
there r many ways to dele the duplicate rows
1.in source qualifies t/r select the DISTINC option
2.in aggreter t/r select the group by port
3.in sorter t/r select the distinc

How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 Answers  

---

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

---

What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  

---

What is confirmed dimension?

3 Answers  

---

What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  

---

HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers   CTS,

---

without using rank transformation how can we rank items by using some other transformations

2 Answers  

---

How union transformation is active ?

2 Answers   Puma,

---

What is metadata reporter?

1 Answers   Informatica,

---

hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  

---

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

---

What are the new features of Power Center 5.0?

0 Answers  

---