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
- 9337 Views
- I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
write a query eg:take emp table and empno,sal,deptno columns
have assume the duplicates.
select * from emp x where rowid>(select min(rowid) from emp
where empno=x.empno
and sal=x.sal
and deptno=x.deptno);
you will only duplicate records in the emp table.
chandumba2005@gmail.com
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Differences between version 7.x and 8.x.
what are the Methods For Creating Reusable Transformations?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How you prepared reports for OLAP?
Design a mapping to load a target table with the following values from the above source?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What does refresh system mean, and what are its distinctive choice?
Is it possible to revert a global repository to local one and why?
What are the performance considerations when working with aggregator transformation?
How to extract the informatica rejected data?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How can we improve session performance in aggregator transformation?
What is the advantage of informatica?
How to create the source and target database connections in server manager?
What is deployment group?
