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
- 10450 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / ravikumar2614
DELETE FROM EMP E1 WHERE ROWID<
(SELECT MAX(ROWID) FROM EMP E2 WHERE E1.ROWID=E2.ROWID)
IF I AM WRONG PLEASE CORRECT ME ON ravi.info2614@gmail.com
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what is the difference between informatica6.1 and infomatica7.1
Explain direct and indirect flat file loading (source file type) - informatica
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is the function of aggregator transformation?
What is a grid in Informatica?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Why union transformation is an active transformation?
What is lookup transformation?
What is a code page?
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are session parameters ? How do you set them?
Clarify the aggregator change?
What are the various types of transformation?
