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 / ajit kumar pradhan

if it is a relational source then click on source Qualifier
properties then check Distinct option.

if it is a flat file then it can't work .......

click on target defination select target menu and click
generate/execute then it come out one dialog box come out
then check primary key check box..it avoid duplicale row...

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

State the differences between sql override and lookup override?

1112


which one is better performance wise joiner or look up

1025


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2027


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1864


What is the maplet?

1040


How to generate sequence numbers?

1028


When do you use sql override in a lookup transformation?

1023


Have you worked with/created Parameter file

1610


What is the session task and command task?

986


How to load a Dimension ? and how to load a fact table?

1369


What is the commit type if you have a transaction control transformation in the mapping?

968


explain abt ur project architecture?

2121


How to update a particular record in target with out running whole workflow?

1531


Write the advantages of partitioning a session?

1200


How to extract sap data using informatica? What is abap? What are idocs?

1083