2 Replies Latest reply on Nov 2, 2020 7:23 PM by Jharana Patra

    Multiple Lookups - Best Practice?

    Diane Royer Guru

      I am working on a mapping to import a flat file into Salesforce.  I need to look data from the mapping up three different ways in Salesforce to check for existing records.  What would be the best, most efficient way to do this?

       

      Would it be best to have multiple lookups, multiple sources joined using outer joins, or use the SQL or Lookup override?

       

      I have never used the SQL or Lookup override, so if those are best practice could you give me a little direction on setting it up?