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 records in a flat file source?

Answer Posted / sushanth1234

Connect the flat file to sorter tx and make ascending and connect from sorter to aggregator
tx make group by port and one o/p port count(port) after use router tx 2 group 1)count<0 and 2)count=0 transfer to target for both group Unique and dublicate.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are batches?

1108


How do you manage the Parameter files while migrating your data from one environment to another environment?

1039


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2263


Explain lookup transformation in informatica

1083


What are the types of schemas we have in data warehouse and what are the difference between them?

953


What you know about transaction control transformation?

1005


What is InformaticaPowerCenter?

1144


where to store informatica rejected data?

1105


what is the -ve test case in your project.

2425


How to elaborate tracing level?

1189


What is Index Caches size?

1126


What are the new features of informatica 9.x in developer level?

1007


how to create user defined function (udf) in informatica

1315


update strategy transformation in informatica

1074


How many dimensions are there in informatica?

1102