How to merge First Name & Last Name?

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

Question Posted / kumar

8 Answers
19373 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to merge First Name & Last Name?..

Answer / saradhi

by using concatination operator u can get it.
firstname||lastname

Is This Answer Correct ?

15 Yes

1 No

How to merge First Name & Last Name?..

Answer / giri

Very Simple Use Expression transformation add condition Concat(firstname+lastname)

Is This Answer Correct ?

7 Yes

0 No

How to merge First Name & Last Name?..

Answer / ramesh.b

Use Expression transformation write condition Concat(firstname,lastname)

Is This Answer Correct ?

5 Yes

0 No

How to merge First Name & Last Name?..

Answer / jvdwhinfo

Hi guys,

Here all the above answers are absolutely correct.
i.e we can use both concatenate operators as well as pipe
operators.We gonna get the desired output.
But only difference is the performance.We'll get better
performance by using pipe (||) operator rather than
concatenate.

Please let me know if you want to give further suggestions.
Thanks.
James

Is This Answer Correct ?

4 Yes

0 No

How to merge First Name & Last Name?..

Answer / abinitiofreak

we have to use firstname||lastname expression

Is This Answer Correct ?

2 Yes

1 No

How to merge First Name & Last Name?..

Answer / 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

How to merge First Name & Last Name?..

Answer / sarvesh

it is very simple by using expression trans

Is This Answer Correct ?

3 Yes

6 No

How to merge First Name & Last Name?..

Answer / tejeya

Find the space by using the Instr() function and then split
into two.. then merge.

Is This Answer Correct ?

2 Yes

6 No

Post New Answer