8 Replies Latest reply on Jul 28, 2020 3:00 PM by Amit Majumder

    Null match on lookup

    scuser21766 New Member

      I'm using Informatica cloud. I have an update with multiple lookups where 1 of the fields is optional, if it's null it shouldn't update the field, but if it's not null it should update it with the output from the lookup. I haven't been able to find a way around this. Since Informatica is matching null on null, it's returning multiple lookup values and generating an error. Does anyone have a suggestion?

       

      Thanks.