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 is workflow? What are the components of the workflow manager?
What is workflow? What are the components of workflow manager?
Which version configuration tool used in ur project?
Explain the shared cache and re-cache?
What is lookup change?
Describe expression transformation?
What is substr in informatica?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
If informatica has its scheduler why using third party scheduler?
Explain about Informatica server process that how it works relates to mapping variables?
Can we create two repositories on same database instance in oracle?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is mapping debugger?
How can we use batches?