Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete duplicate records if we have huge volume of
records in a table ?
(rowid is not the correct approach)
- 6 Answers
- 10072 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 informatica metadata and where is it stored?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the meaning of up gradation of repository?
What is the fact table?
What is primary and backup node?
what is $$$$?
What are the informatica performance improvement tips
Different circumstance which drives informatica server to expel records?
Explain about cumulative Sum or moving sum?
What is a passive transformation?
Could you explain what is enterprise data warehouse?
What are the various types of transformation?
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
What happens when a session fails and you click on recover?
What is the status code in stored procedure transformation?
