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
- 9506 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
where to store informatica rejected data? How to extract the informatica rejected data?
What is meant by LDAP users?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Do you find any difficulty while working with flat files as source and target?
What is union transformation?
how tokens will generate?
is it possible to index the data in cache of lkp transformation ?
How do you load only null records into target?
permutations of mapplet
can we override a native sql query within informatica? Where do we do it? How do we do it?
How do you migrate data from one environment to another?
What is flashback table ? Advance thanks
Whats the difference between informatica powercenter server, repositoryserver and repository?
Clarify the aggregator change?
What is main use of mapplet?
