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
- 9076 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
What is a node in Informatica?
What is rank transform?
How are indexes created after completing the load process?
Explian the Process of deployment groups in informatica
how we can load rejected record's at run time?(not through bad files)
What the difference is between a database, a data warehouse and a data mart?
What is sq transformation?
What does command task mean?
Differentiate between joiner and lookup transformation?
Explain the etl program with few examples.
Explain informatica architecture - version 8 / 9
Differentiate between source qualifier and filter transformation?
What are Dimensional table?
Explain transaction control transformation in informatica
What is Data Caches size?
