write a query for how to eliminate the duplicate rows
without using distinct?
Answer Posted / mani
DELETE FROM EMP WHERE ROWID NOT IN (SELECT MAX(ROWID)FROM
EMP)GROUP BY EMPNO;
Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
what is $$$$?
What is dynamic cache?
Which development components of informatica have the highest usage?
What is persistent lookup cache?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Differences between connected and unconnected lookup?
Which files are created during the session rums by informatics server?
Explain lookup transformation source types in informatica
What is status code in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are data-driven sessions?
What is enterprise data warehousing?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Can we override a native sql query within informatica?
What does “tail –f” command do and what is its use as an Informatica admin.