write a query for how to eliminate the duplicate rows
without using distinct?
Answer Posted / madhu
DELETE FROM EMP WHERE ROWID NOT IN (SELECT MAX(ROWID)FROM
EMP GROUP BY EMPNO);
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are different types of transformations available in informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How you prepared reports for OLAP?
Suppose we do not group by on any ports of the aggregator what will be the output?
Is it possible to use a client with different version than that of its Informatica server?
Which transformation is needed while using the Cobol sources as source definitions?
Explain the tuning lookup transformation - informatica
What is main use of mapplet?
Name the different lookup cache(s)?
How might one distinguish in the case of mapping is right or not without associating session?
Why is sorter an active transformation?
What is standalone command task?
Explain your project of banking domian.
What is lookup transformation?