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

What is meant by query override?

1043


What is session task and command task?

1264


Under which circumstances, informatica server creates reject files?

1075


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2435


Explain the mapping variable usage example in informatica

1134


What is informatica? Why do we need it?

1082


Differentiate between Load Manager and DTM?

2142


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1093


What are the restrictions of union transformation?

1018


What is a transaction control transformation?

1180


How to do unit testing in informatica? How to load data in informatica ?

1093


What are the settings that you use to configure the joiner transformation?

1039


What is workflow? What are the components of workflow manager?

1159


What is the need of an ETL tool?

1072


What are multi-group transformations?

1071