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 will you remove the duplicate records from flat file
without using sorter?

Answer Posted / krishnakanthch

We can use the option 'SELECT DISTINCT' in the source
qualifier.

Anybody please tell me whether this works or not.

Is This Answer Correct ?    5 Yes 23 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Briefly explain the aggregator transformation?

949


What is status code in informatica?

968


How to Create a folder using pmrep command?

1118


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2107


Explain scd type 3 through mapping.

926


Clarify the utilization of aggregator cache record?

956


what is the difference between informatica6.1 and infomatica7.1

2199


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2010


What is Session and Batches?

1048


When do you use sql override in a lookup transformation?

1035


What is a standalone command task?

1148


What are roles and groups and benefits of using them?

1007


Explain the difference between mapping parameter and mapping variable?

988


What are pre and post-session shell commands?

1249


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2517