Informatica – How to concatenate the first and last name – Expression Transformation

Using expression transformation we can combine two strings to a single string and load to target. Here we are going to concatenate First Name & Last name and storing to a new column in target as Full Name using CONCAT function in the expression transformation.

Source Table
employees

Target Table
emp_tgt_Exp_string

Transformation
Expression

Function
CONCAT (or) (||)

To concatenate first & last name with no space in between.

build an expression using CONCAT function. We can also use the symbol ‘||’ instead of function.  all the below expressions will give the same results.

CONCAT(FIRST_NAME,LAST_NAME)
FIRST_NAME || LAST_NAME

To concatenate first & last name with space in between, all the below expressions will give the same results.

CONCAT(CONCAT(FIRST_NAME,’ ‘),LAST_NAME)
CONCAT(FIRST_NAME,CONCAT(‘ ‘,LAST_NAME))
FIRST_NAME || ‘ ‘ || LAST_NAME

***

If you have any further questions, please do send an e-mail to kvtinformatica@gmail.com.