I am trying to sync the Warehouses table and am getting an error initializing the synce because there is a filed "MainRefillingWarehouseID" that is related to the key "WarehouseID". I have a warehouse ID 10 that is the refilling warehouse for a lot of other warehouse so I need to load the table with warehouse 10 the other records are created.
How can I handle an initialization like this? I'm sure this is a common pattern of "parent-child" relationships that comes up in other areas as well.
The map is below and is inherently mapped correctly once the data is loaded.
Nope, that is the approach, Dual Write struggles with referential data and always has. I am not aware of any solution for this at the moment. Your approach is the only real option!
I couldn't find another option so I ended up altering the data to load the warehouse record.
1. Remove the transit and refilling warehouse from the warehouse records.
2. Load the warehouse records
3. Reload the refilling and warehouse records.
I don't know if there is a better approach for self-referential tables but this worked to get the dual write working in my test and prod environments.
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156