When you configure a delta extraction, the Secure Agent does not fetch the change indicators marked for insert, delete, or update for delta records from SAP. Hence, the delta rows that are extracted from the source are marked for upsert by default.
When you perform a delta extraction and if the row is available in the
SAP
target table, the Secure Agent updates the delta records to the target table. If the row is not available, the Secure Agent inserts the records to the
SAP
target table.
If multiple transactions such as insert, update, or delete occurs for the same record in the SAP source, the Secure Agent fetches only one record. However, if an operation, for example, an insert for a record occurs in the SAP source table and you run the mapping, the Secure Agent fetches the inserted record. Later, if an update occurs for the same record in the SAP source table and you run the delta extraction mapping, the Secure Agent fetches the updated record.
When you perform a delta extraction for the deleted records in the SAP table, the Secure Agent fetches only the key value of the deleted delta records to the target table.
ASK INFAPreview
