Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

Explain scd type 3 through mapping.

1051


Can informatica load heterogeneous targets from heterogeneous sources?

1227


What is meant by query override?

1112


COM components can be used in Informatica

2450


What is data caches/ index caches?

1166


How are indexes created after completing the load process?

1716


How to load the data from a flat file into the target where the source flat file name changes daily?

1096


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?

1814


Can you generate sequence numbers without using the sequence generator transformation?

1156


What is the format of informatica objects in a repository?

1073


What is lookup transformation?

1088


How can one identify whether mapping is correct or not without connecting session?

1493


What are the measure objects?

1251


What are the tuning techniques you applied during your last project

2072


What is a repository? And how to add it in an informatica client?

1192