Interested to Buy Any Domain ? << Click Here >> for more details...
write a query for how to eliminate the duplicate rows
without using distinct?
- 6 Answers
- 12148 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / mani
DELETE FROM EMP WHERE ROWID NOT IN (SELECT MAX(ROWID)FROM
EMP)GROUP BY EMPNO;
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
Target increases every day even though no new record was inserted
Define mapping and session?
What is difference between a gateway node and worker node?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Explain the difference between a data warehouse and a data mart?
What is rank transformation in informatica
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
COM components can be used in Informatica
What is decode in static cache?
Can we override a native sql query within informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What are the main features of Oracle 8i with context to datawarehouse?
Enlist the tasks for which source qualifier transformation is used.
How to generate sequence numbers?
What is transformation?
