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

How to join three sources using joiner? Explain though mapping flow.

1147

---

What is the benefit of partitioning a session?

1182

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1248

---

What are the informatica performance improvement tips

1093

---

what are 3 tech challenges/ common issues you face?

2346

---

What is the difference between router and filter?

1269

---

can we override a native sql query within informatica? How do we do it?

1126

---

how to load dimension table and fact table. plz tell me the steps.

2094

---

Tell me about Propagate functions in informatica

922

---

Make a note of the quantity vaults made in informatica?

988

---

Differentiate between router and filter transformation?

1012

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2456

---

What are the different versions of informatica?

1275

---

What is target load order?

1247

---

scenario where i can use only concurrent execution of workflow.

3173

---