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...

i have 2 flat files one table contains duplicates another one
no duplicates.... so i need like this i don't want
duplicates...pl's give me ans...

Answer Posted / ankit kansal

Hi Gow,
As Question specified there are two source files so you can not user Distinct clause in Source Qualifier.

http://deepinopensource.blogspot.com/

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

991


How do you convert single row from source into three rows into target?

1091


What are session parameters ? How do you set them?

1773


How might you approve all mappings in the archive all the while?

956


What is flashback table ? Advance thanks

1872


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1603


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

1996


What is olap (on-line analytical processing?

1007


State the differences between sql override and lookup override?

1113


Can we create two repositories on same database instance in oracle?

1015


What is the command used to run a batch?

994


What is a rank transform?

1024


What the difference is between a database, a data warehouse and a data mart?

1080


What is the different lookup cache(s)?

1034


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

2028