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
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the new features of informatica 9.x in developer level?
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?
What are the static cache and dynamic cache in informatica?
Can we get 1st record through Informatica(without sequence number).
Define sessions in informatica etl?
Explain dynamic target flat file name generation in informatica
What is a predefined event?
What is a joiner transformation?
What are the new features of Power Center 5.0?
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.
Whats the difference between informatica powercenter server, repositoryserver and repository?
Is it possible to define a single node as a Gateway node as well as worker node?
How many dimensions are there in informatica?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?