Thread: Case Conversion functions - Upper, lower, initcap - informatica

As most of the databases support the case conversion functions, Informatica also provides the capability of converting a string from one case to the other.

The syntax of the case conversion functions are shown below:

Code:

UPPER(string)
LOWER(string)
INITCAP(string)

The upper function converts a string to capital letters. Example:

Code:

upper('inforMAticA') returns INFORMATICA

The lower function converts a give string to the lower case letters. Example:

Code:

lower('Power CEnter') returns power center

The Initcap function converts the first character in each word to the upper case and remaining characters to lower case letters. Example:

Code:

initcap('etl TOOL') returns Etl Tool