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
- 9080 Views
- I also Faced
- E-Mail Answers
Answer Posted / vivek singh
select * from emp1
where rowid not in (select max(rowid) from emp1 group by empno);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a pre-defined event and user-defined event?
How to elaborate tracing level?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are the different lookup cache(s)?
How does a rank transform differ from aggregator transform functions max and min?
Suppose we do not group by on any ports of the aggregator what will be the output?
How to generate sequence numbers using expression transformation?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
can anyone suggest best free Talend data integration training online
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is a dimensional model?
What are the static cache and dynamic cache in informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How you can differentiate between connected lookup and unconnected lookup?
What is incremental aggregation?
