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

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

2049


What are roles and groups and benefits of using them?

1104


Is it possible to create multiple domains on a single Informatica server?

1291


What is the difference between a connected look up and unconnected lookup?

1003


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7370


what is the size ur source like(file system or database)? how many record daily come u r banking project?

2193


Mention some types of transformation?

1097


How to load data in informatica ?

1070


What are the differences between a connected lookup and unconnected lookup?

1126


As union transformation gives UNION ALL output, how you will get the UNION output?

1159


can u give example for factless fact table

6783


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2780


what is the Default Source Option For Update Strategy Transformation?

1287


Briefly describe lookup transformation?

1097


Difference between Data and Index Caches?

1207