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
- 9079 Views
- I also Faced
- E-Mail Answers
Answer Posted / teja_dwh
use this query u will get this.For example i am taking emp
table
select * from emp where rowid not in(select max(rowid) from
emp group by empno)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what are the deliverables?in your project?
What do think which one is the better joiner or look up?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Enlist the advantages of informatica.
Explain about Informatica server process that how it works relates to mapping variables?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How many number of sessions can one group in batches?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to elaborate tracing level?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Plz can any one say me how to get the informatica certification materials and dumps
