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

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2128


What do you mean by channel change?

1051


What is the different lookup cache(s)?

1092


How is union transformation utilized?

1016


Explain about Informatica server process that how it works relates to mapping variables?

1088


have u done any performance tuning? how u ll do?

2299


What are the new features of Power Center 5.0?

1784


How would you copy the content of one repository to another repository?

1025


How can we delete duplicate rows from flat files?

1231


scenario where i can use only concurrent execution of workflow.

3180


What are the databases that informatica can connect to windows?

1058


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1296


How to load last n records of file into target table - informatica

1083


How many input parameters can exist in an unconnected lookup?

1550


What are the types of lookup transformation?

1083