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 are the differences between joiner transformation and source qualifier transformation?

1180


what is informatica metadata?

1045


Explain the aggregator transformation?

1174


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1093


can any one give some examples for pre sql and post sql(Except dropping and creating index).

4118


How to call shell scripts from informatica?

1001


Describe data concatenation?

1088


Could you explain what is enterprise data warehouse?

1157


what is song in infrmatica...?

2243


What is data movement mode in Informatica and difference between them?

1147


Have you worked with/created Parameter file

1668


How can we create index after completion of load process?

1133


What are the types of schemas we have in data warehouse.

966


How can you generate reports in informatica?

1040


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9837