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 is workflow? What are the components of the workflow manager?

894


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

930


Which version configuration tool used in ur project?

2978


Explain the shared cache and re-cache?

829


What is lookup change?

824


Describe expression transformation?

874


What is substr in informatica?

901


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

1669


If informatica has its scheduler why using third party scheduler?

1011


Explain about Informatica server process that how it works relates to mapping variables?

826


Can we create two repositories on same database instance in oracle?

849


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.

1059


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.

1421


What is mapping debugger?

756


How can we use batches?

796