How to delete duplicate records if we have huge volume of
records in a table ?
(rowid is not the correct approach)
- 6 Answers
- 9364 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 is the size of your data warehousing?
What is a connected transformation?
What are the popular informatica products?
Is it possible to use a client with different version than that of its Informatica server?
What is a sorter transformation?
How we can create indexes after completing the loan process?
waht type of interface is used for testing the data in informatica
Describe data concatenation?
How to use pmcmd utility command?
What is workflow? What are the components of workflow manager?
Write the different tools in the workflow manager?
What is the surrogate key?
What do you understand by a term domain?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How to do unit testing in informatica? How to load data in informatica ?
