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
- 9274 Views
- I also Faced
- E-Mail Answers
Answer Posted / teja_dwh
use this query u will get this.For example i am taking emp
table
select * from emp where rowid not in(select max(rowid) from
emp group by empno)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What can we do to improve the performance of informatica aggregator transformation?
How to create the source and target database connections in server manager?
What are pre and post-session shell commands?
What are the different transaction levels available in transaction control transformation?
How to create or import flat file definition in to the warehouse designer?
what is unit testing?tell me proceedure
What is intricate mapping?
What is rank transform?
what is the size of your data warehousing?
What do you understand by term role-playing dimension?
Differentiate between source qualifier and filter transformation?
Explain about Informatica server process that how it works relates to mapping variables?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Describe data concatenation?
How can we use mapping variables in informatica?
