Interested to Buy Any Domain ? << Click Here >> for more details...
In a table there are 1 million records there in which 3
records are duplicate how will you find out those 3 records?
- 6 Answers
- 9338 Views
- I also Faced
- E-Mail Answers
Answer Posted / lokesh vepanjeri
select * from emp where rowid not in (select max(rowid)
from emp group by empno);
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
When do you use sql override in a lookup transformation?
What are the types of lookup transformation?
Explain the tuning lookup transformation - informatica
Explain transaction control transformation in informatica
How to differentiate between the active and passive transformations?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Mention few power centre client applications with their basic purpose?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the static cache and dynamic cache in informatica?
wat are deployement groups in informatica, how it will be used for developers
What could be the possible resons of locks by user?
What is a stored procedure transformation?
What is the need for an etl tool?
Briefly define reusable transformation?
What is dimensional table? Explain the different dimensions.
