How to merge First Name & Last Name?

Answer Posted / venkateshmalneni

let the source is like this
first name last name
venkatesh malneni
rajesh tumalla
siva kalle

use an expression t/r create an output port with condition first name||last name
CONNECT THE OUTPUT TO THE TARGET

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the main features of Oracle 8i with context to datawarehouse?

1769


Difference between Data and Index Caches?

766


What is a sequence generator transformation?

667


Explain pushdown optimization and types in informatica

747


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1673






What is a surrogate key?

669


What is domain and gateway node?

801


Under which circumstances, informatica server creates reject files?

685


What is a filter transformation?

672


Explain the scenario which compels informatica server to reject files?

753


Write the advantages of partitioning a session?

853


What is primary and backup node?

803


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

894


Write the different tools in the workflow manager?

662


Define joiner transformation?

672