-
Notifications
You must be signed in to change notification settings - Fork 83
Description
After reading this https://help.sfdmu.com/faq/sfdmu-data-insertion-and-limitations/can-child-records-with-a-self-lookup-field-be-inserted-in-a-single-job I know that child records with a self-lookup field can't be inserted in a single job but can they be inserted in a multiple ones?
If my understanding is correct it will always Insert all records with the self-reference field set to null. Unfortunately I'm using a managed package where there is a validation that parentId has to be populated so even if I split records into multiple jobs I get an error.
Here is an example:
First job:
Id,Name,pse__Parent_Region__c,pse__Parent_Region__r.Name
aDR0Y0000004R85WAE,Global,,
Second job:
First job:
Id,Name,pse__Parent_Region__c,pse__Parent_Region__r.Name
aDR0Y0000004R8AWAU,Europe,aDR0Y0000004R85WAE,Global
message: "Region requires a parent. There are too many top-level Regions in the system.: 2,,Europe"
Is there a way how can I skip the first insert with self-reference field set to null and insert it with already evaluated reference?
Thanks in advance!