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

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1629


Explain how many types of dimensions are available in informatica?

1090


How to differentiate between the active and passive transformations?

1157


How can you increase the performance in joiner transformation?

1183


What are the main features of Oracle 8i with context to datawarehouse?

2109


What is the need of etl tools?

1111


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2129


What is an active transformation?

1093


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4725


without table how to come first record only in oracle?

2247


Why update strategy and union transformations are active?

1036


What is confirmed fact in dataware housing?

6955


How to join three sources using joiner? Explain though mapping flow.

1140


What does “tail –f” command do and what is its use as an Informatica admin.

1096


How to call shell scripts from informatica?

992