CONCAT In Informatica

CONCAT is used to concatenate two strings. Also using the || string operator instead of CONCAT improves PowerCenter Integration Service performance.

Syntax

CONCAT( FIRST_STRING, SECOND_STRING )

Return Value:

Returns string value.If any of the string is NULL then CONCAT ignores it and returns the other string.If both strings are NULL then it returns NULL

Example

CONCAT( STREET_ADD,STATE_ADd)

CONCAT( CONCAT( FIRST_NAME, ' ' ), LAST_NAME )