3 Replies Latest reply on May 12, 2021 6:27 AM by Jharana Patra

    set default value when more than one rows return in lookup

    Nihar BHATT Active Member

      Hi ,

       

      I have created one lookup in information CDI tool as follows. Now the issue is this lookup returns more than one rows.

      What i want to rather than information generates the error when more than 1 output value gets returned I want to send a default value.

       

      The other option in Multiplicity is to pick random values among the returned rows. But I do not want to use that option rather I want to return null when more than one row gets returned.

       

      is that possible Informatica CDI ?

       

      Mapping screenshot

       

      Thanks,

      Nihar