vmaitra1
New Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Join with Merge functionality
Hi Patan, You can try left outer join with $original.path as join condition for both left and right paths. Merge will simply combine the left and right docs and if there is a difference in count then it will join incorrectly. With left outer join all the output docs for create will be present with the corresponding fetch results. Thanks, V2.2KViews0likes0CommentsSalesforce Lookup vs Read
Hi, I am designing a salesforce - salesforce flow (source and target systems are different) and have several steps in between where I need to fetch ids of dependent objects for mapping. Salesforce Lookup snap serves the purpose but as per SnapLogic documentation, for every record an individual request will be sent. Is Salesforce Read snap (I will have to use Rest API) a better option? Will only one request be sent to salesforce for multiple input documents (ie, same object but different ids which will be used in where clause)? Wanted to understand which has a better performance for a data vol of 16k. Thanks, V3.3KViews0likes2Comments