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
- 9272 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 transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Explain why we use partitioning the session in informatica?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How many input parameters can exist in an unconnected lookup?
What's the layout of parameter file (what does a parameter file contain?)?
Can informatica load heterogeneous targets from heterogeneous sources?
can anyone suggest best free Talend data integration training online
What are the limitations of joiner transformation?
How to extract the informatica rejected data?
What is an Integration service in Informatica?
Explain target update override 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 the Methods For Creating Reusable Transformations?
Explain the types of transformations?
