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

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?

593


What are the mapping parameters and mapping variables?

616


Explain the difference between mapping parameter and mapping variable?

600


Explain Dataware house architecture .how data flow from intial to end?

2118


How to elaborate tracing level?

681






What are the transformations that are not supported in mapplet?

591


Explain constraint based loading in informatica

653


What is domain in terms of informatica?

557


What is the need of an ETL tool?

635


What is standalone command task?

699


How do you load only null records into target? Explain through mapping flow.

1490


How can we use mapping variables in informatica?

595


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1736


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4766


how many types of dimensions are available in informatica?

555