19 February 2019
In case if you are using UPSERT operation in your package then ID mapping is required. The UPSERT operation updates a record if it exists or inserts a new record. This allows you to avoid inserting duplicate data. In Skyvia, UPSERT determines what action to perform in the following way: if a Null value is specified for the ID or primary key, UPSERT operation inserts the record, and if a non-null value is specified, UPSERT operation tries to update the record with the specified ID or primary key. Please refer to:
If you are using INSERT operation, then please send us DDL script of your target PostgreSQL table.
Thank you and looking forward to your reply.