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 / aswin

use aggregator and do not apply any aggregation function, it will return only last row in the group..if you dont provide any groupby and aggregate value it will return only last row..so you can aviod dups

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define filter transformation?

1142


How to do unit testing in informatica? How to load data in informatica ?

1177


I have a flat file, want to reverse the contents of the flat file

1167


What is the difference between a connected look up and unconnected lookup?

996


How are indexes created after completing the load process?

1713


Could you explain what is enterprise data warehouse?

1220


Sequence generator, when you move from develoment to production how will you reset

2119


What are the steps involved in the migration from older version to newer version of Informatica Server?

2149


Explain the pipeline partition with real time example?

1193


what is the complex transformation you used in informatica

2621


Which transformation should we use to normalise the COBOL and relational sources?

1265


What is meant by target load plan?

1026


What is confirmed fact in dataware housing?

7097


Explain 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?

1055


How many numbers of sessions can one group in batches?

1101