Hi
I have an incremental table with soft deletes enabled in my extract layer (data area). Additionally, I have set up an incremental rule for the SQL data source in the ODX. I was wondering if an hard delete occurs in the SQL data base, will the ODX still be able to detect this such that the incremental table in the data area can mark the record as TombStone?
Best answer by Thomas Lind
Hi
Soft or hard deletes can only be detected if it has been set on the data source in the ODX / Ingest instance.
When deletes are turned on on the data source it will create an extra table or folder ending in _PK. This contains all primary key variations there is in the source. This is then compared to what is in the valid table and then it will remove or set the check in the data area table.
+5Hi
Soft or hard deletes can only be detected if it has been set on the data source in the ODX / Ingest instance.
When deletes are turned on on the data source it will create an extra table or folder ending in _PK. This contains all primary key variations there is in the source. This is then compared to what is in the valid table and then it will remove or set the check in the data area table.
Thank you,
+5Hi
Yes, when you have done that it will add a true false value to the added tombstone field.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
