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

My source data like...

Empid Name
10 chandra
10 sekhar

I am expecting result is

Empid Ename
10 Chandrasekhar

How can we solve this prob?

Answer Posted / shaik mahamad rafi

first use concatenate operator '',then use union

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8265


What are the new features of informatica 9.x in developer level?

1052


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1123


What are the static cache and dynamic cache in informatica?

1243


Can we get 1st record through Informatica(without sequence number).

1518


Define sessions in informatica etl?

1101


Explain dynamic target flat file name generation in informatica

1109


What is a predefined event?

1134


What is a joiner transformation?

1035


What are the new features of Power Center 5.0?

1846


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2325


Whats the difference between informatica powercenter server, repositoryserver and repository?

1221


Is it possible to define a single node as a Gateway node as well as worker node?

1184


How many dimensions are there in informatica?

1134


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1382