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
- 10457 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
have u done any performance tuning? how u ll do?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How do you promote a non-reusable transformation to reusable transformation?
Explain how many types of dimensions are available in informatica?
What is xml source qualifier transformation in informatica?
What is standalone command task?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Is it possible to define a single node as a Gateway node as well as worker node?
What are the components of the workflow manager?
What is workflow? What are the components of workflow manager?
What is joiner change?
What is fact table? Explain the different kinds of facts.
Performance tuning in UNIX for informatica mappings?
Could you explain what is enterprise data warehouse?
