How to delete duplicate records if we have huge volume of
records in a table ?
(rowid is not the correct approach)
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
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
tell me the rules and responsblites in our project(my project is development)
Define Pmrep command?
In which transformation you cannot drag ports into it?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the status code in stored procedure transformation?
What is blocking transformation?
What do you understand by term role-playing dimension?
How can we store previous session logs?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How do you load first and last records into target table?
What is Data Caches size?
my source is junk data how will u remove that junk data by using unix please any one replay me
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?