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 )
No comments:
Post a Comment