Unable to Update the destination table

Support Queries Astera Centerprise
1

Hi,

I have 2 destination tables

  1. Account (used for inserting)

  2. Contact (that needs to be updated with AccountID of Account inserted in step 1)

When I pass accountID from Account to Contact and map it with the field shown in the image below, the Contact table does not update with AccountID. You may see the Contact Destination Table screen right below. But when the final process is run, the Contact table is not updated with AccountID. Could you suggest what should be done?

image
image939×775 154 KB

2

I see you have the bulk insert option selected. What you are trying to do will not work in this mode. Try changing the setting to a single record insert to do this.