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

What is the difference between writing a joiner query in ANSI style and THETA style?

2336


Explain pmcmd command usage in informatica

1078


Plz can any one say me how to get the informatica certification materials and dumps

2011


Difference between Target-based loading and constraint-based loading?

956


Mention some types of transformation?

1002


What is dynamic cache?

982


Explain what is informatica metadata and where is it stored?

998


Partition, what happens if the specified key range is shorter and longer

2444


What does role playing dimension mean?

1006


What is the procedure for creating independent data marts from informatica 7.1?

1015


what is the hint? how to use it to reduce the query processing in program?

7661


What is meant by lookup transformation? Explain the types of lookup transformation?

908


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

1713


What are pre and post-session shell commands?

1249


What are the components of workflow manager?

1029