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.
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.
FIRST_NAME || LAST_NAME
To concatenate first & last name with space in between, all the below expressions will give the same results.
FIRST_NAME || ‘ ‘ || LAST_NAME
If you have any further questions, please do send an e-mail to firstname.lastname@example.org.