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

What is the difference between informatica 7.0 and 8.0?

952


How do you load alternate records into different tables through mapping flow?

1802


What is informatica metadata and where is it stored?

932


How many ways are there to create ports?

1234


How are the sources and targets definitions imported in informatica designer?

1050


what are the Methods For Creating Reusable Transformations?

1099


Enlist some properties of sessions.

1021


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7266


In how many ways we can create ports?

1067


What is Index Caches size?

1055


What is incremental aggregation?

1014


COM components can be used in Informatica

2313


What is the session task and command task?

991


What are roles and groups and benefits of using them?

990


Which transformation should we use to normalise the COBOL and relational sources?

1141