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

How to delete duplicate record in Informatica?

Answer Posted / sarvesh

create table newtable as select distinct * from original
tablename;
by doing this we can elimate the duplicate rows

Is This Answer Correct ?    6 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How we can use union transformation?

1001


Describe data concatenation?

1021


What is a rank transform?

1040


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1066


What is Session and Batches?

1049


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1986


What is source qualifier transformation in informatica?

953


According to his methodology what all you need before you build a datawarehouse

1716


What are multi-group transformations?

1025


Explain lookup transformation in informatica

1021


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

2198


Explain direct and indirect flat file loading (source file type) - informatica

1275


What are the reusable transformations?

1108


Which means the first record should come as last record and last record should come as first record and load into the target file?

1031


What are the types of caches in lookup?

983