Loaded records few getting updated in the target tables instead of inserted

[Abhilasha G T]

Hi Team,

I have loaded around 805 records to customer_account table , before i load data to the table ,not having single record also , as we expect all 805 records should get inserted with no errors.

 but few records getting updated say around 13 ,  how to find the reason behind it.

can anyone suggest here.

Regards,

Abhilasha G T

[Appanna M]

Hello @Abhilasha G T ,

There are couple of debugging steps you have to perform. 

1. Check Import Set & Skipped Records: Verify the Import set logs why the 13 records got ignored/skipped.

2. Check the load data for those 13 records if there are any mandatory fields missing.

3. Review Transform Map: Check the field mapping & transform scripts by putting some gs.debug messages.

4. Enable Debugging: In the logs it should clearly specify the ignore reason so you will come to understand.  

Please Mark My Answer as Helpful and Accept as Solution, if you find this article helpful or resolves your issue.