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 do you set a varible in incremental aggregation

1832

---

What is a repository manager?

1041

---

Explain what are the different types of transformation available in informatica.

1059

---

What is the cumulative sum and moving sum?

1151

---

without table how to come first record only in oracle?

2215

---

can you please explain me pre session and post session options?

7443

---

What are the main issues while working with flat files as source and as targets ?

1112

---

What are the popular informatica products?

969

---

Define pmcmd command?

1000

---

What is difference between a gateway node and worker node?

1083

---

Explain sessions. Explain how batches are used to combine executions?

963

---

What is confirmed fact in dataware housing?

6844

---

What is sq transformation?

1092

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

977

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1591

---