Results 1 to 2 of 2

Thread: Concat multiple strings in informatica

  1. #1
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    512

    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.

  2. #2
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    512
    How to concatenate multiple strings in one shot?

    Informatica provides this functionality with the use of || operator. Use the || operator to concatenate any number of strings. An example is shown below:

    Code:
    'Informatica||' '||'ETL Tool'

Similar Threads

  1. Replies: 0
    Last Post: 03-04-2013, 09:07 AM
  2. Replies: 0
    Last Post: 03-04-2013, 08:11 AM
  3. Replies: 1
    Last Post: 03-03-2013, 03:12 PM
  4. Create Multiple rows from single row - informatica
    By vijay in forum Data Warehouse
    Replies: 1
    Last Post: 03-01-2013, 09:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •