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

source
file name xyz

a,0,a,a,a
b,b,b,0,b
c,c,c,0,c

target should be like this

xyz
a
b
c


how to implement this?

Answer Posted / amedela chandra sekhar

By using sorter t/r select distinct option
it eliminate the duplicates.

Is This Answer Correct ?    0 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does an informatica transformation support only aggregate expressions?

970


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?

6353


How do you handle two sessions in Informatica

1073


What is native users?

1100


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

2031


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

1370


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

1014


What is informatica? Why do we need it?

1038


Differentiate between sessions and batches?

962


How to create or import flat file definition in to the warehouse designer?

1021


Explain what are the different versions of informatica?

1031


Explain the aggregator transformation?

1093


What do think which one is the better joiner or look up?

1143


What are the different types of repositories created using informatica?

1059


What are the transformations that are not supported in mapplet?

955