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 / infa dev

Source and the target will the same table from which the
duplicate needs to be deleted from. Then use a lookup trans
on to this same table and then use an update trans with
DD_DELETE if the row is duplicate else do nothing.

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of an aggregator cache file?

1199


Difference between Data and Index Caches?

1137


How to generate sequence numbers?

1088


what is INFORMATICA TESTING process

2294


Separate from a database, an information bazaar, and an information stockroom?

1089


What's the layout of parameter file (what does a parameter file contain?)?

2385


Explain the etl program with few examples.

1051


Explain about cumulative Sum or moving sum?

1043


Quickly characterize reusable change?

1121


what is informatica metadata?

1037


What is a mapplet/worklet in informatica?

1188


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2325


What the difference is between a database, a data warehouse and a data mart?

1155


What is the use of transformation?

998


Please let me know how to make Data masking in informatica..

1726