How to concatenate the first and last name – Expression Transformation

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) (||)

source-employee-table
Here is the source table employee with first_name and last_name.
informatica-expression-mapping
Create a mapping with source, expression transformation & target

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

informatica-expression-concat-function
Give the CONCAT function in expression editor
informatica-expression-concat-fullname
Hers is the target table result, Full-name with no space in between

 

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

informatica-expression-concat-function
Give the CONCAT function in expression editor
informatica-expression-concat-fullname
Hers is the target table result, Full-name with space in between.

***

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

You May Also Like

About the Author: kvt

Leave a Reply

Your email address will not be published. Required fields are marked *