how do u fnd the duplicate rows and how to delete the
duplicate rows?
Answers were Sorted based on User's Feedback
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);
Is This Answer Correct ? | 21 Yes | 3 No |
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
Is This Answer Correct ? | 5 Yes | 4 No |
How to delete duplicate records in a flat file source?
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Enlist some properties of sessions.
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
How to delete the data in the target table after loaded.
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
What are the joiner caches?
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
What is the need of building a data warehouse?