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

How would you copy the content of one repository to another repository?

1058


What is the different lookup cache(s)?

1128


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1330


What are the different versions of informatica?

1332


Parameter and variable differences

2104


What are the measure objects?

1251


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

2004


Explain lookup transformation source types in informatica

1151


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1119


Why update strategy and union transformations are active? Explain with examples.

1281


What are the prerequisite tasks to achieve the session partition?

1293


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2297


What is mapping debugger?

1067


Differentiate between joiner and lookup transformation?

1157


How do you change a non-reusable transformation to reusable transformation?

1046