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 a flat file, in which i have two fields, emp_id,
emp_name. The data is like this,
emp_id,emp_name
101,soha
101,ali
101,khan
102,siva
102,shanker
102,reddy.
how to merge the names so that my output is like this
Emp_id Emp_name
101 Soha ali kahn
102 siva shenkar reddy

please provide solution

Answer Posted / shirish

In expression transformation use an output port ...in
expression window write emp_id||empname

Is This Answer Correct ?    7 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Different circumstance which drives informatica server to expel records?

983


State the limitations where we cannot use joiner in the mapping pipeline?

1065


What are the new features of Power Center 5.0?

1777


Write the prerequisite tasks to achieve the session partition?

1156


What is a filter transformation?

1043


Explain what is informatica metadata and where is it stored?

1049


How can we handle two sessions in informatica?

1031


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1794


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2003


What are the conditions needed to improve the performance of informatica aggregator transformation?

1093


Define filter transformation?

1096


Explain what are the different types of transformation available in informatica.

1145


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2131


can anyone explain me about retail domain project in informatica?

7946


4 yrs etl devloper roles and responsibilities?any body give solutions

2168