Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

CONCAT - Join two strings in Informatica

  1. Forget Code
  2. Informatica
  3. CONCAT - Join two strings 
CONCAT( FIRST_NAME, LAST_NAME )

First_NameLast_NameResult
JohnCooperJohnCooper
NULLCooperCooper
JohnNULLJohn
NULLNULLNULL
10201020


However usage of concat function is slower and it is efficient to use Concatenation Operator