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

what is the difference between stop and abort?

3 Answers   TCS,

---

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,

---

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

---

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,

---

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

---

What is the target load order?

3 Answers   HCL, Informatica,

---

What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,

---

what type of problem you faced insales project or insurance project

1 Answers   Sony,

---

How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  

---

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

---

Define filter transformation?

0 Answers  

---