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
- 10292 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
Why do we need informatica?
What are the types of lookup transformation?
Explain your project of banking domian.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What are the tasks that can be performed using sq?
What are the different versions of informatica?
How can we use mapping variables in informatica?
What are the data movement modes in informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is aggregate cache in aggregator transformation?
What is a snowflake schema?
How to load the data from people soft hrm to people soft erm using informatica?
What are multi-group transformations?
Describe expression transformation?
What are the types of data warehouses?
