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

Is there any target staging area in informatica not staging area

2625


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1226


Enlist the advantages of informatica.

1097


While importing the relational source definition from the database, what are the metadata of source that will be imported?

1311


Explain joiner transformation in informatica

1170


What are some examples of informatica etl programs?

981


Design time, run time. If you don't create parameter what will happen

1888


What is lookup transformation?

1088


difference between informatica 8.1.1 and 8.6

3728


How can repository reports be accessed without sql or other transformations?

1264


Explain in detail about scd type 1 through mapping.

1622


How you know when to use a static cache and dynamic cache in lookup transformation?

1913


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2351


What are the different transaction levels available in transaction control transformation?

1269


can anyone suggest best free Talend data integration training online

1741