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 / gow

Hi Teja

We can use distinct option in source qualifier of the table having duplicate records itself right? Why do we need to use sorter after the source qualifier?.

Please correct me if i am wrong.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2036


How to create a non-reusable instance of reusable transformations?

1135


What are the types of presistent cache in look up tr.

2055


What is difference between a gateway node and worker node?

1141


What are mapplets?

1274


What are the advantages of using informatica as an etl tool over teradata?

1022


Can anyone tell me the new features in Informatica 9 Version?

2130


As union transformation gives UNION ALL output, how you will get the UNION output?

1108


without table how to come first record only in oracle?

2256


Differentiate between reusable transformation and mapplet.

1097


How to improve the performance of a session using sorter transformation?

1146


Write the prerequisite tasks to achieve the session partition?

1160


what are the Methods For Creating Reusable Transformations?

1175


What is rank index in rank transformation?

1080


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?

1677