Results 1 to 2 of 2

Thread: If else logic in informatica

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

    If else logic in informatica

    How to implement the if else logic in informatica. Example is shown below:

    Code:
    if ( id =10 )
    {
       value = "Id id 10";
    }
    else
    {
      value = "id is not 10";
    }

  2. #2
    Senior Member
    Join Date
    Jun 2012
    Posts
    105
    Informatica has the IIF conditional expression. The syntax is

    Code:
    IIF(condition, return_true, return_false)
    If the condition is true, then the return_true part will be returend. Otherwise return_false will be returned. You can nest multiple IIFS.

    You can also use the DECODE function in informatica to achieve the same result.

Similar Threads

  1. linked server time out logic
    By Oracleguy in forum Oracle
    Replies: 0
    Last Post: 12-24-2012, 04:41 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
  •