Pages

Wednesday, March 13, 2013

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 )

No comments:

Post a Comment