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

What are the different options available for update strategy?

1047


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1983


What are session parameters ? How do you set them?

1899


Implementation methodology

1768


Why do we need informatica?

1052


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2248


What is the scenario which compels informatica server to reject files?

1118


What are the types of lookup transformation?

1117


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2182


can you please explain me pre session and post session options?

7665


What is the surrogate key?

1357


What is difference between a gateway node and worker node?

1199


What are the limitations of joiner transformation?

1176


What do mean by local and global repository?

1276


what is mean by complex business rule ?

2217