Thread: Concat multiple strings in informatica

The concat function in informatica concatenates only two strings. The syntax of concat function is

Code:

concat(string1, string2)

Example:

Code:

concat('Informatica','ETL Tool') returns "InformaticaETL Tool"

You can see in the above output there is no space between Informatica and ETL words. The concat function does not allow us to specify a delimiter. There is workaround for this use two concat functions as shown below:

Code:

concat(concat('Informatica,' '),'ETL Tool') returns "Informatica ETL Tool"

The inner function first concatenates the Informatica and space delimiter. The outer function concatenates the result of inner concat function and the "ETL Tool" word.