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 are the different versions of informatica?

1180


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2138


 Informatica Checkpoints

3267


How can you validate all mappings in the repository simultaneously?

1286


Explain the code page compatibility?

1021


What is the function of aggregator transformation?

1015


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7113


What are the conditions needed to improve the performance of informatica aggregator transformation?

1033


Parameter and variable differences

2003


What are the tasks that can be performed using sq?

1023


Explain lookup transformation source types in informatica

1039


Explain the etl program with few examples.

965


explain abt ur project architecture?

2121


What is a surrogate key?

1015


What is workflow manager?

986