Help get this topic noticed by sharing it on
Twitter,
Facebook, or email.


Get lookup Id values for load table
if you are creating a load table and you need to query Salesforce for lookup ID values, what is the best way to do this using bulk operations? or do you use a query?
-
It all depends on the source data.
If the other object has an external id and you know that value, you can use that as the lookup value and force salesforce to lookup the actual id.
If you want to stick with regular salesforce ids, then it is a question of volume. If your load table has 100K records, then avoid looking up foreign key ids one at a time. Instead, write a query to download the id and any other columns needed and lookup against the local table.
On the hand, if the load table is just 5 rows for example, looking up values with a query against the linked server table is fine. -