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
- 9335 Views
- I also Faced
- E-Mail Answers
Answer Posted / haribabu
select ename,empno,count(*) from emp group by empno having count(*)>1;
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is rank transform?
Describe an informatica powercenter?
Can you use flat files in Mapplets.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are the differences between a connected lookup and unconnected lookup?
permutations of mapplet
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is the sql query overwrite in source qualifier in informatica
How you can differentiate between connected lookup and unconnected lookup?
what is SDLC way of code development?
What is native users?
what is the hint? how to use it to reduce the query processing in program?
What is the surrogate key?
How to do unit testing in informatica?
