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
- 9507 Views
- I also Faced
- E-Mail Answers
Answer Posted / lokesh vepanjeri
select * from emp where rowid not in (select max(rowid)
from emp group by empno);
| 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 the use of an aggregator cache file?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is the difference between router and filter?
How to extract sap data using informatica?
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 need for an etl tool?
Different circumstance which drives informatica server to expel records?
Explain how many types of dimensions are available in informatica?
what is index?how it can work in informatica
what is the complex transformation you used in informatica
What are the uses of etl tools?
can u give example for factless fact table
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
update strategy transformation in informatica
