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...

write a query for how to eliminate the duplicate rows
without using distinct?

Answer Posted / abhishek kumar

select id from tgt_table group by id;

Is This Answer Correct ?    7 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dimensional table?

1025


How big was your fact table

1762


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?

1123


Is it possible to define a single node as a Gateway node as well as worker node?

1077


Differentiate between reusable transformation and mapplet.

1050


How to partition the Session?

1066


What are data-driven sessions?

1162


What is a predefined event?

1056


What is difference between a gateway node and worker node?

1090


How do you load first and last records into target table?

1126


What is a code page?

1137


Mention a few design and development best practices for informatica?

958


Write the program through which the records can be updated?

963


What is a joiner transformation and why it is an active one?

1031


What is InformaticaPowerCenter?

1093