How to delete duplicate records if we have huge volume of
records in a table ?
(rowid is not the correct approach)
- 6 Answers
- 9433 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / chandu
select * from from <table_name> where rowid not in(select
min(rowid) from <table_name> group by column(primary or
unique key column))
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the main issues while working with flat files as source and as targets ?
What are different types of transformations available in informatica?
How can we improve session performance in aggregator transformation?
server hot-ws270 is connect to Repository B. What does it mean?
define galaxy repository in informatica
What is the function of union transformation?
What can we do to improve the performance of informatica aggregator transformation?
In which transformation you cannot drag ports into it?
Differences between connected and unconnected lookup?
Under what condition selecting sorted input in aggregator may fail the session?
How you prepared reports for OLAP?
Explain the shared cache and re-cache?
How to delete duplicate row using informatica?
Explain informatica architecture - version 8 / 9
What is the fact table?
