When loading data incrementally, Incorta inserts new records and updates existing records that have already been loaded, but by default it does not delete records. Source systems like Oracle Cloud ERP, however, may allow users to delete data. This means that if records are deleted in the source, those records may still exist in Incorta. Fortunately, there are options for how to manage source deleted records in Incorta and subsequently BigQuery.
Note: This uses Oracle Cloud ERP as an example. If the source is a Oracle database then the only change would be that the user would need to create a PK table via a sql query which gets the PK fields of the source table instead of sourcing the data from the BICC VO .
.png "Employee"){kind=icon}
