Delete from emp where rowid not in(select min(rowid) from emp group by eid,

How to delete duplicate records if we have huge volume of
records in a table ?
(rowid is not the correct approach)

Question Posted / dilip ingole

Answer Posted / dilip ingole

Delete from emp where rowid not in(select min(rowid) from emp group by eid,ename)

in group by column you need mention all column in table

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are some examples of informatica etl programs?

884

How many ways are there to do 'remove duplicate records in informatica'?

953

What are multi-group transformations?

1010

What are the different types of olap? Give an example?

972

What is the difference between a connected look up and unconnected lookup?

910

How to differentiate between the active and passive transformations?

1070

What is mapping debugger?

941

what is the -ve test case in your project.

2327

What is an expression transformation?

967

What is a sorter transformation?

1033

What is intricate mapping?

1090

lookup transformation with screenshots

3938

what is the size of u r source(like file or table)?

2198

Does an informatica transformation support only aggregate expressions?

967

Explain the scenario which compels informatica server to reject files?

1086